Thread: ending zero
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default 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