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
What I need displayed is
Avatar of Mark Drelinger
Mark Drelinger
Flag of United States of America image


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

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

Link to home
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!