removing comma in data string
On Jan 3, 2:28 pm, Dave Peterson wrote:
How about selecting the range to fix
edit|Replace
what: , (a comma)
with: (leave blank)
replace all
wrote:
I have a string of numbers, but they've been entered as:
357,041
332,224
341,038
etc.
Basically I'd just like to convert them to numbers so I can add,
subtract, etc. The problem is that as they are right now, they are
stored as text, and I can't figure out how to fix that (format cells
number does nothing).
Please help.
--
Dave Peterson
Got rid of the commas, didn't solve the text/number situation. For
some reason it refuses to store it as a number.
|