AllenRitch
Technical User
I have a spreadsheet that was developed by exporting from a database (I don't have access to this database and cannot have the information re-ran).
One of the columns has currency data, however, I cannot add or change the format. An example of the data within a cell appears as $45,652.32 when I view it's contents from the formula bar.
I've tried copying the data into a new column using several different methods (e.g. paste specail), but the only thing that works is double clicking within the cell and then hiting enter. Doing so somehow changes the data and removes the dollar signs and commas. I can then manipulate. But seeing how there's over 2,500 rows, I'm hoping there's an easier way.
Thanks for any help you might could provide.
One of the columns has currency data, however, I cannot add or change the format. An example of the data within a cell appears as $45,652.32 when I view it's contents from the formula bar.
I've tried copying the data into a new column using several different methods (e.g. paste specail), but the only thing that works is double clicking within the cell and then hiting enter. Doing so somehow changes the data and removes the dollar signs and commas. I can then manipulate. But seeing how there's over 2,500 rows, I'm hoping there's an easier way.
Thanks for any help you might could provide.