Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Nov 2008
    Location
    Winchester, Hampshire, United Kingdom
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    format mask for numbers (Excel 2007 )

    Hi all
    I'm trying to find a way to apply a mask to number input so that all numbers are three digits - so "1" would show as "001", "10" as "010" and so on. I know I can format numbers as text, but I don't really want to do that, and users will still only enter "1" instead of "001". Is there a way of doing this - I know there is in Access, but I can't find a way in Excel 2007 to do it, and data validation doesn't seem to cover this
    thanks

  2. #2
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: format mask for numbers (Excel 2007 )

    In Excel 2003 you can just format the cells with a custom number format of 000
    I would be very surprised if this doesn't work the same on Excel 2007.

    StuartR

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: format mask for numbers (Excel 2007 )

    Select the cells that you want to format.
    On the Home tab of the Ribbon, click the little arrow to the right of Number. This activates the number format dialog.
    Select Custom in the Category list.
    Enter 000 in the Type box.
    Click OK.

  4. #4
    New Lounger
    Join Date
    Nov 2008
    Location
    Winchester, Hampshire, United Kingdom
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: format mask for numbers (Excel 2007 )

    Thanks to you both - I had tried that but used "###" instead of "000". It works now
    thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •