+ Reply to Thread
Results 1 to 4 of 4

Show Zero value in front of my numbers

  1. #1
    Registered User
    Join Date
    02-22-2007
    Posts
    8

    Show Zero value in front of my numbers

    I'm working with a set of numbers that are 9 digits long but are not social security numbers so I don't need the dashes. However, some of my numbers may have zero's at the beginning. When I type the 0 number it automatically hides the zero. How can I get the number to show?
    For example
    Number 005121111 shows as 5121111 but I need the zeros.
    Any help would be greatly appreciated!!!!

  2. #2
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    right click on cell, go to format, click on number tab, in category, click custom, type nine zeroes

    Let me know if that works

  3. #3
    Registered User
    Join Date
    02-22-2007
    Posts
    8
    OMG you are a genious! That worked, thank you so much!

  4. #4
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    Glad I could help.

+ 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