find and delete a character from multiple columns
How about doing a find and replace (Ctrl + H)? Replace the $ with nothing.
When this is done Excel should do an implicit conversion of the text to
number... If you want you can record a macro while doing this.
--
HTH...
Jim Thomlinson
"scrocker" wrote:
I have a Excel spreadsheet that is an export of data from Microsoft CRM
3.0 In a number field that should be a dollar amount CRM is exporting
the $ which is being broght into Excel as Number stored as Text, I
would like to write either a macro of VBA script that would either
convert the cell to currency or delete the $ for each sell that the $
is in, in the spreadsheet. Does anyone know how to do that. Any help
would be greatly appreciated.
Thanks in advance.
|