View Poll Results: Who are you ?

Voters
1. You may not vote on this poll

  • Member

    1 100.00%

  • Friend

    0 0%
+ Reply to Thread
Results 1 to 3 of 3

Thread: Creating Number Format

  1. 09-03-2009, 07:14 AM #1
    Asanka
    Asanka is offline
    Registered User
    Join Date
    09-03-2009
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2007
    Posts
    2

    Smile Creating Number Format

    Hi All

    I want to automated number format as follows.

    When I enter 25 in the cell it should appear as 0000025
    another example when I enter 510 in the cell it should appear as 0000510

    If any one know the way to do that please help me.
    Last edited by Asanka; 09-03-2009 at 07:19 AM.
    Reply With Quote Reply With Quote
  2. 09-03-2009, 07:20 AM #2
    Asanka
    Asanka is offline
    Registered User
    Join Date
    09-03-2009
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Creating Number Format

    Hi All
    Please guid me to that in excel 2007
    Reply With Quote Reply With Quote
  3. 09-03-2009, 07:33 AM #3
    romperstomper
    romperstomper is offline
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    Apparently I can't say
    MS-Off Ver
    Apparently I can't say
    Posts
    8,274

    Re: Creating Number Format

    Right-click, choose Format cells, on the Number tab choose Custom and enter:
    0000000
    My wife is a pharmacist and she brings home thebacon.

    My MVP profile
    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0