+ Reply to Thread
Results 1 to 3 of 3

make:Custom Number Format

  1. #1
    Registered User
    Join Date
    04-04-2005
    Location
    Bahama, NC
    Posts
    59

    make:Custom Number Format

    Hello all I need to know how to create a format that would make a number XXXXXX, into XXXXXX0000. Adding zeroes to the back end instead of the front end. Any ideas? Please let me know.
    Thanks,
    Bob

  2. #2
    Steve Dalton
    Guest

    re: make:Custom Number Format

    Can't you just multiply the number by 10000?

    Steve


    "robertjtucker" <robertjtucker.21do3n_1136827501.5509@excelforum-nospam.com>
    wrote in message
    news:robertjtucker.21do3n_1136827501.5509@excelforum-nospam.com...
    >
    > Hello all I need to know how to create a format that would make a number
    > XXXXXX, into XXXXXX0000. Adding zeroes to the back end instead of the
    > front end. Any ideas? Please let me know.
    > Thanks,
    > Bob
    >
    >
    > --
    > robertjtucker
    > ------------------------------------------------------------------------
    > robertjtucker's Profile:

    http://www.excelforum.com/member.php...o&userid=21805
    > View this thread: http://www.excelforum.com/showthread...hreadid=499446
    >




  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,777
    Without knowing the details, it's hard to say if this is a good option, but a format of general"00000" will display a handful of 0's to the right of whatever is in the cell without changing the value stored in the cell.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1