cell will not change
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?
|