Is there a format for numbers like 2,500,000.55?

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

Guest

In other words is it possible to have a comma seperator between thousands but
also two decimal places where required?

And can you get the number to display no decimal places if none are
required, i.e. the number ends .00?

So far my research tells me this isn't possible but I though I'd double
check with your access wizards. :D
 
You must log in or register to reply here.

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

Hanging decimal places with custom number format 2
Number Format 2
format a number field to only show 2 decimal places if there are a 6
Stop Rounding in Forms 2
Comma Style Question 3
Automatically chnage number format of a range of cells 2
Formating Issue in a Query 1
Formatting problem with numbers in query 1

Back
Top