Number Stored as text - Tried every possible way

[muneshmeena]

Hi there,

after importing the data from a report file, when used calculation got #value error. when checked found that the value in cells is not stored number, for this i used =isnumber() & =istext() formula.
I searched the net, tried every solution I found but no solution for me. Please find the attached excel file and do something if you can.

[protonLeah]

Your numeric cells have 11 spaces preceeding digits: use =TRIM(B2)

[muneshmeena]

protonleah perhaps ypu not read my problem. I tried every possible way... find below sheet after using =trim()

[FDibbins]

I think Ben missed the multiple , in your text. Try this....
=TRIM(SUBSTITUTE(SUBSTITUTE(B2,"-",""),",",""))*1

If the values are meant to be negative, use this...
=TRIM(SUBSTITUTE(SUBSTITUTE(B2,"-",""),",",""))*-1.

If there is a mix of pos and neg, use this...

=TRIM(SUBSTITUTE(SUBSTITUTE(B2,"-",""),",",""))*IF(ISNUMBER(SEARCH("-",B2,1)),-1,1)

[muneshmeena]

FDibbins many many thanks...its working.

please take a look at my another post.....i'll be greatful