Hi Peo - when I entered the formula you suggested it did not return 1 and
simply blue outlines the cell in question when the formula is selected. Any
other suggestions?

"Peo Sjoblom" wrote:

The 4 is probably text, make sure there are no hidden characters, try

=LEN(A1)

where A1 is the cell with 4, if it returns 1, then copy an empty cell,
select A1 and do edittpaste special and select add, now try to format the
cell as currency


Regards,

Peo Sjoblom


"Alyssa" wrote in message
...
The cell is currently showing a single digit, eg. 4. I want it to display
$4.00. However when I format the cell to currency with 2 decimal places -
nothing happens. What am I doing wrong?