Tools - Options Edit - Check fixed decimal places (ensure the number is 2)
--
HTH...

Jim Thomlinson


"Nonie" wrote:

Hi there,

I want excel to return "$.59" if I type in "59" and "$1.59" if I type in
"159"

Is there a way to do this?

Thanks!