text as number
 

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.

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.

text as number
 

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.

text as number
 

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.

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.