Convert numbers stored as text to numbers
Thank you..........
"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
A number of options worth looking at:
Data/ Text to Columns
Copy a zero (or an empty cell) and then Edit/ Paste Special/ Add to your
range of text numbers
(or similarly Edit/ Paste Special/Multiply by 1)
--
David Biddulph
"Stig - tame racing driver" wrote in
message ...
Help!! i'm going mad
how do you Convert numbers stored as text to numbers useing a formula
(normaly comes up with and error..... but not today)
Thanking you
|