Text Numeric to Numeric

Am copying bank statement from online banking. The numeric colum is in text format. how to change it to numeric format, so that addition of entries can be made there itself.....

my online search gave the following tip as solution...but it doesnt work :(

 

pls help me out (if this topic has already been discussed here in the forum, pls give me the link )


• Select an empty cell in your worksheet and type a 1.
• Copy the cell containing the 1
• Select the range of data that is stored as text
• Select Edit| Paste Special
• Select Multiply from the Operation section of the dialog box
• Click on OK

All of the data will now be numeric and you are able to analyze and perform mathematical calculations on it.

Replies (4)

 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

Shailesh
 

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details
Company
13 November 2026
Chartered Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA

View Details
Company
30 October 2026
Asst Manager Accounts

Goodwin Pumps India Pvt Ltd

Chengalpattu

CA Inter

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
Featured ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details
Company
21 November 2026
Asst. Manager / Deputy Manager

Aco Perfumes & Cosmetic Pvt Ltd

Mumbai

CA

View Details
Company
ARTICLESHIP 16 November 2026
Audit Executives

Loonker Godawat And Company

Bengaluru

B.Com

View Details
Company
19 November 2026
Accounts & Taxation Executive

MCSR and Associates LLP

Hyderabad

CA Inter

View Details