Change "Text Numbers" to "Numbers"

N

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
 
F

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'
 
Top