Link to home
Start Free TrialLog in
Avatar of Mark Drelinger
Mark DrelingerFlag for United States of America

asked on

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

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
Avatar of Mark Drelinger
Mark Drelinger
Flag of United States of America image

ASKER

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

Amount: Format([GROSS],"00000000") & Right(Format([GROSS],0),2)
ASKER CERTIFIED SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
PERFECT!  Thank you.
You are welcome!