Cant apply format currency to a cell.

  • Thread starter Thread starter Mario
  • Start date Start date
M

Mario

I copy, pasted the Access's querry result into excel. I
can format one of the columns into currency. Even after I
do there is no change.

Please help.
 
If you copy from Access 2002 and paste into Excel, the numbers are
pasted in as text. You'll have to change them back to numbers before you
can format them:

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
 
Back
Top