Home – New Forums Other discussions Can anyone help me ‘clean up’ an Excel spreadsheet? Reply To: Can anyone help me ‘clean up’ an Excel spreadsheet?

#1070024
John C.
Member
  • Total posts: 439
Up
0
::
mnj’s buyers group, post: 87239 wrote:
I’m am really a complete novice at excel and usually stumble across my answers by mistake.

Has the format of your column been changed some how. Right click on your colums and make sure that the format is for currency.

Hey over a thousand entries anything is worth a try!!:D

I agree it’s worth checking the cell format on that column, although it’s possible that there is a problem with a formula rather than the inverted commas being the cause of the problem – double check that you haven’t incorrectly copied a formula and caused a loop or are referencing the wrong cells or something.

If you have no luck you’re welcome to email me the document and I’ll have a look at it for you.

Best of luck.
John