Carla,

Methinks your client has poor memory. What you see is what is intended.

You probably need to format the cell as Number, with 2 dec places,
FormatCellsNumber.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Carla" wrote in message
...
Maybe this is how it's supposed to work, but my client says it's not. She
has
fixed decimal set under tools, options with 2 decimal places. However she
said in the past she could type 25. and it would show up as 25.00 and if
she
typed 25 it would show up as .25 but now either way she types it the
result
is .25 and she wants it to be the way it used to be. So my question is
what
is the best way to do this and how is it supposed to work?

Thanks,
Carla