We help IT Professionals succeed at work.

number formatted for exactly 10 characters, but not displaying the decimal point, AND including the leading zeros.

Mark Drelinger
on
50 Views
Last Modified: 2019-03-06
I have a number field in access query that I need to be exactly 10 character long with leading zeros and including the cents, but no decimal.

What I have formatted now:
Amount: Format([GROSS],"00000000.00")
which displays
00000124.58
What I need displayed is
0000012458
Comment
Watch Question

Author

Commented:
This seems sloppy, but did appear to work - is there a better way ?

Amount: Format([GROSS],"00000000") & Right(Format([GROSS],0),2)
CERTIFIED EXPERT
Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

Commented:
PERFECT!  Thank you.
CERTIFIED EXPERT
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
You are welcome!