>.
>
Just formatting your cell to general, doesn't change the value in the cell. (If
it was "text" numbers, it's still text numbers. But the next time you change
the cell, xl will see it as a number.)
You could format the cells as General. Then hit F2, enter for each cell. But
the copy|paste special|Add is much, much quicker.
--
Dave Peterson
ec3...@msn.com
1. Select an empty cell on the worksheet
2. Choose Edit>Copy
3. Select the cells that you pasted from Access
4. Choose Edit>Paste Special
5. Select Add, click OK
If you do this frequently, you can use a macro to convert the numbers.
I use this one (written by Jon Peltier):
Sub ConvertToNumbers()
Cells(65535, 255).Copy
Selection.PasteSpecial Paste:=xlPasteValues, _
Operation:=xlPasteSpecialOperationAdd
End Sub
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html