text to values
Sorry, disregard my answer...not a macro.
Kevin
"Kevin Stecyk" wrote in message
...
Snax,
You could use a formula such as in cell B1
=RIGHT(A1,LEN(A1)-1) where A1 was your '100 value.
Just copy the formula down.
In essence, it says, take the right most characters, except the very first
charcter (length - 1).
Hope that helps.
Regards,
Kevin
"snax500" wrote in message
om...
In Excel2000, what is the best way to code a macro that will convert a
column of text to values. For example, I have the following in column
A:
'100
'1000
'20
I want this to be converted to values like this:
100
1000
20
Thanks
|