Solved Copy and paste bank statement

July 16, 2013 at 03:28:36
Specs: Windows 7
Hi i have just copied and pasted a years worth of bank statements into an excel spreadsheet but am unable to total any of the figures as they are not recognised as an excel format. I have tried all the various formatting options but to no avail. the only thing that works is to insert a new column and reimput all the figures!!! Your help would be greatly appreciated

See More: Copy and paste bank statement

Report •

July 16, 2013 at 03:43:39
1 - Select an empty cell
2 - Do a Ctrl-c to Copy
3 - Select the numbers you need to Sum
4 - Right-click...Paste Special...Add

This should convert the text strings to numbers.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

July 16, 2013 at 06:31:50
✔ Best Answer
Since your having problems with your imported numbers, I would not be surprised if your Dates are also not Real Date, but Text that looks like Dates.

A quick way to determine if you have Real Dates is to format the cell as Number.
If it is a Real Date it will display as a 5 digit number.

If your dates are Text, see here for how to convert to Real Dates:


Report •
Related Solutions

Ask Question