can't sum up items i cut&paste from access to excel..
i can't sum up no.'s i cut&paste from access to excel. excel recognizes the
correctly cut&paste values as "zero" and so when i add up the columns, i get a zero for the total. |
can't sum up items i cut&paste from access to excel..
They have probably come across as text rather than numbers. In a spare
column you can enter the formula: =VALUE(A1) assuming your data starts in cell A1, then copy this down for the extent of your data. Highlight all the cells with this formula in, then click copy | Edit | Paste Special | Values | OK and press <enter, then copy all these cells to overwrite the data in column A. You can delete the column where the formula was entered. Pete |
All times are GMT +1. The time now is 05:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com