ending zero

  • Thread starter Thread starter george m
  • Start date Start date
G

george m

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trouble converting smallmoney to decimal 1
calculating currency formatted fields 7
how do i separate cell value in four different cells? 1
PivotTable Custom Field - formula for no value, with blank cell displayed? 6
Rounding Pennies 1
Trailing zero's 4
Regex.IsMatch help 8
Handling hhmmss time format 6

Back
Top