Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ending vba | Excel Programming | |||
Ending a macro? | Excel Programming | |||
Ending zero | Excel Discussion (Misc queries) | |||
ending subs | Excel Programming | |||
Ending Sub | Excel Programming |