text as number
--Copy a blank cell
--Select the range of numbers (to be converted) in your spreadsheet
--Right clickPasteSpecialSelect Add. and click OK
If this post helps click Yes
---------------
Jacob Skaria
"a m spock" wrote:
i have received a spreadsheet with some numbers which seem to be entered as
text. i am not able to convert them back to numbers with =value(text). can
someone please help.
|