Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2008
    Location
    Albuquerque, New Mexico, USA
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a spreadsheet with a column of numbers. I need all the numbers to have 3 zeros in front of the numbers and remove the single ' in front of the number. Is there a simple way to format the cells to remove this symbol ' and add the 3 zeros in front without having to just simply retype every cell?

    Never mind...I figured it out
    '000314123002
    '000428221001
    '000422585001
    '438871001
    '423653001
    '373421001
    '423590001
    '423484001
    '374372001
    '373418001
    '331320002
    '421902001
    '422153001
    '423487001
    '421847001

  2. #2
    New Lounger
    Join Date
    May 2008
    Location
    Albuquerque, New Mexico, USA
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Never mind...I figured it out. 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
  •