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.
CAclubindia
