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?

#1070033
Five Star PA
Member
  • Total posts: 64
Up
0
::

Ok I worked it out! Have to say weird thing I’ve come across in awhile!

What I did is convert the excel file to a csv.

then I opened an MS Access new database and imported this csv file. Once imported I change the settings of the columns to be number and currency formats and then created a formula and it worked.

If for some reason you then needed to view this in excel you could always export it as excel.

Hope that helps!

Meredith
http://www.fivestarpa.com