Hi,
Select the range and then go to Data Text columns. Just click on Finish
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"a m spock" wrote in message
...
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.