View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jkrich@gmail.com is offline
external usenet poster
 
Posts: 6
Default removing comma in data string

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.