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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

format number

Status
Not open for further replies.
Daya100

Daya100

Programmer
Joined
Jan 11, 2002
Messages
21
Location
US
I'm trying to format a number so that it is 4 characters long. For example 1 would be 0001 and 15 would be 0015. How do I do that?
Thanks!
 
Sort by date Sort by votes
If you put "0000" in the format property you should get what you want.

E.g.,

format(15,"0000") will display the number 15 as "0015"

-- Herb
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ameedoo3000
  • Locked
  • Question Question
format partition by vba code
Replies
6
Views
1K
mattKnight
mattKnight
lameid
  • Locked
  • Helpful tip Helpful tip
Richtext Format in tables - Default vs. Embedded font...
Replies
0
Views
383
lameid
lameid
lameid
  • Locked
  • Question Question
Richtext Format in tables - Default vs. Embedded font...
Replies
2
Views
443
lameid
lameid
TheresAlwaysAWay
  • Locked
  • Question Question
Need help finding where a number lies within a set of values
Replies
3
Views
429
TheresAlwaysAWay
TheresAlwaysAWay
Moss100
  • Locked
  • Question Question
Sending a number of PDF's (in a report or other approach)
Replies
3
Views
404
sxschech
sxschech

Part and Inventory Search

Sponsor

Back
Top