Cant apply format currency to a cell.

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

 

[Debra Dalgleish]

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