Is there a way to always show two decimal places

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

Guest

What I want to do is always show two decimal places even if the number is 13
or the percentage is 13. So I would want the numbers to look like 13.00 and
13.00%? Is there a way to do this?

Thanks in advance
 
John said:
What I want to do is always show two decimal places even if the
number is 13 or the percentage is 13. So I would want the numbers to
look like 13.00 and
13.00%? Is there a way to do this?

Thanks in advance
Click to expand...
Format(YourNumber;"0.00")

--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa1 - I° Conferenza Italiana per Sviluppatori Access Arezzo 4+5
Giugno 2005 Sono aperte le iscrizioni Info: www.donkarl.com/it
 
if i=13, then
=format(i,"#.00")
will give you 13.00

and

=format(9/18,"#.00%")
will give you 50.00%
 
Back
Top