Change "Text Numbers" to "Numbers"

[Nichole]

Hello,
Can you tell me how to (with a macro) change a range of
cells that have text numbers to real numbers so I can use
them in formulas and also have them show up as real
numbers if I save the file as a .prn file. The range of
cells begin in row 2 from column C through column AZ. I
would really appreciate your help. I have spent days on
this and I'm still lost.
Thank You,
Nichole

 

[Frank Kabel]

Hi
try the following:
- set the format for these cells to a 'number' format'
- select an empty cell and copy this cell
- select your range of text numbers
- goto 'Edit - Paste Special' and choose 'Add'

 

[Guest]

Frank,
Oh my gosh...that works great. Oh my gosh...Thank you
soooo much!!!!!!