Text Numeric to Numeric

 It should work. try again.

Or you can use below vba macro code to convert it to value

Sub convvalue()

For Each d In Selection

d.Value = d.Value

Next

End Sub

Goto VBA Editor by pressing Alt-F11 or Tools>Macro>Visual Basic Editor

Insert Module

Paste above code & run with your text numric cells selected.

From VBA Editor press F5 or from Excel Tools>Macro>Macros>select convvalue & click on run  button.

Shailesh

Shailesh ji You are most welcome in this forum. actuly i was waiting for genious persons like you . you can also help me for serch commond. Party wise, sundry debtors detail. in Excel 2007 in VBA Programe.

Party Name & Contct No.

Bill   Date   Amount

                     Total

Thanks

Shailesh ji,

thanQ for your immediate response. Thanx for the code…but sorry to say that it still doesn’t work. Now I have attached the file with the text (numeric). The figures have an empty space after decimcals (this i found only after posting the query here). If I remove it manually in each cell, ur code and the online available tip, both works…but, its not possible to remove that xtra space na for that many entires....!!!!

Originally posted by : bhuvana
	Shailesh ji,   thanQ for your immediate response. Thanx for the code…but sorry to say that it still doesn’t work. Now I have attached the file with the text (numeric). The figures have an empty space after decimcals (this i found only after posting the query here). If I remove it manually in each cell, ur code and the online available tip, both works…but, its not possible to remove that xtra space na for that many entires....!!!!

Use below vba code.

Sub conv2value()

For Each d In Selection

d.Value = CDbl(d)

Next

End Sub