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?

#1070025
Luth6322
Member
  • Total posts: 82
Up
0
::

Did a little bit of searching for you.

I’m assuming the import has used a CSV format to import it into Excel, and this is why you have the quotes around the numbers.

From what I can tell you should be able to get rid of this by doing a text to coloumns.

I would also check that the file is actually saved as an Excel file and not a csv or txt file.

Have no idea is this will help, but thats all I could find.

Hope it helps.

Cheers

Carrie