Format to General

--Hit Ctrl+H (Replace window)
--From replace window
find , (comma)
replace (blank)
--Hit OK

If this post helps click Yes
---------------
Jacob Skaria


"a m spock" wrote:

thanks

1. this is a copy : 4,76,258.33
2. there are no aostrophes.
3. i have tried reformatting

is there any other way i can send a copy of a part of the spreadsheet itself?

i am going mad.


"EricG" wrote:

What do these numbers look like? Is there a single apostrophe at the
beginning of them (i.e. a ' )?

Please provide an example of your data.

Have you tried formatting the cells as "Number"? Are they currently
formatted as "Text" or "General"?

Eric

"a m spock" wrote:

i have received a spreadsheet in which some numbers appear to be entered as
text. i have tried the =value(text) function but am not able to convert them
back to numbers. please help.