Posted to microsoft.public.excel.worksheet.functions
|
|
text as number
=--SUBSTITUTE(A1,",","")
--
David Biddulph
a m spock wrote:
did not work. here is copy of one cell:
4,76,258.33
"Ashish Mathur" wrote:
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.
|