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 Mike Lewis 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
Jan 11, 2002
21
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
format partition by vba code
Replies
6
Views
404
mattKnight
mattKnight
lameid
  • Locked
  • Helpful tip
Richtext Format in tables - Default vs. Embedded font...
Replies
0
Views
114
lameid
lameid
lameid
  • Locked
  • Question
Richtext Format in tables - Default vs. Embedded font...
Replies
2
Views
123
lameid
lameid
TheresAlwaysAWay
  • Locked
  • Question
Need help finding where a number lies within a set of values 1
Replies
3
Views
114
TheresAlwaysAWay
TheresAlwaysAWay
Moss100
  • Locked
  • Question
Sending a number of PDF's (in a report or other approach)
Replies
3
Views
91
sxschech
sxschech

Part and Inventory Search

Sponsor

Back
Top