ending zero
 

How do I stop excel from dropping ending zeros when displaying a amount

The field is defined as currency
if the amount is 250.50 it is displaying 250.5
I need it to display 250.50


Thanks
George

ending zero
 

Check your cell formatting again and make sure it is still set for currency
and that it is set for 2 decimal places.

Regards,
Paul

--

"george m" wrote in message
...
How do I stop excel from dropping ending zeros when displaying a amount

The field is defined as currency
if the amount is 250.50 it is displaying 250.5
I need it to display 250.50


Thanks
George