Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Preceeding Zero's

Status
Not open for further replies.
BROWNIE56

BROWNIE56

Programmer
Dec 28, 2000
31
US
I need to be able to display an account number that will always disply "zero's" before the account number, up to six digits.

Example:
000056
001112
023433
000001

Thank you,
Sharon
 
Sort by date Sort by votes
try this

Totext({table.AccountNum}),"000000")

that should work...please note that this format does not round numbers...rather it truncates them

Hope this helps
Jim
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

hoagieryder
  • Locked
  • Question
Mode of Data with Zero's 1
Replies
1
Views
16
CoSpringsGuy
CoSpringsGuy
TEM3
  • Locked
  • Question
Including Zero's
Replies
9
Views
54
TEM3
TEM3
Bradford847
  • Locked
  • Question
Manual median calculation ignoring zero's 2
Replies
6
Views
73
lbass
lbass
KalebsDad78
  • Locked
  • Question
Removing Zero's from an Average Formula
Replies
2
Views
43
KalebsDad78
KalebsDad78
Yustrn
  • Locked
  • Question
Turn Zero's to Null
Replies
3
Views
22
Madawc
Madawc

Part and Inventory Search

Sponsor

Back
Top