skip to main | skip to sidebar

Ted's Hello World

Monday, June 22, 2009

Padding out a cell with leading zeros in Excel

http://www.mrexcel.com/archive/General/14898.html

=REPT(0,8-LEN(A1))&A1

Or you can use the Format->Custom and enter 0000

Posted by Ted Unnikumaran at 12:19 PM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2011 (1)
    • ►  January (1)
  • ►  2010 (42)
    • ►  November (4)
    • ►  October (1)
    • ►  June (10)
    • ►  May (2)
    • ►  April (5)
    • ►  March (14)
    • ►  February (5)
    • ►  January (1)
  • ▼  2009 (56)
    • ►  December (1)
    • ►  November (4)
    • ►  September (1)
    • ►  August (4)
    • ►  July (2)
    • ▼  June (9)
      • Padding out a cell with leading zeros in Excel
      • Excel Formula to extract the Path from a filename
      • Changing the Icon for an Application
      • How to return a dialog box result
      • Read in a tab delimited file in vb.net
      • How to determine if the Mouse is over a Control th...
      • Detect Active Control on a Form
      • Detect the Ctrl Key plus another key
      • itunes was unable to load provider data from sync ...
    • ►  May (7)
    • ►  April (5)
    • ►  March (7)
    • ►  February (11)
    • ►  January (5)
  • ►  2008 (51)
    • ►  December (7)
    • ►  November (6)
    • ►  October (4)
    • ►  September (4)
    • ►  July (5)
    • ►  June (5)
    • ►  May (5)
    • ►  April (1)
    • ►  March (4)
    • ►  February (8)
    • ►  January (2)
  • ►  2007 (16)
    • ►  December (10)
    • ►  November (6)

About Me

Ted Unnikumaran
View my complete profile