0 after decimal point

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Access 2003, I want to display engine sizes in a vehicle database i.e.
1.6, 2.5, 2.0 etc. How do I display the 0 after the decimal point?

Thanks in advance
 
In that case

format(int(Number), "#.0")

0402486 said:
Sorry............... I should have mentioned I'd like to format the cell in
the table to read 1.0, 2.0 etc
 

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

Back
Top