Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel
I have an Excel spreadshee with 16000 Employee Numbers. I need to put a
Zerro in front of each number to have a nine didget number. It can not go at the back it has to go in front of the number. Is there a formula that would put the number in front of the 8 didget number or do I have to select each cell and add it one by one. Thanks. -- Newfie |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel
If you want to turn them into text strings, either
=0&A1 or =TEXT(A1,"000000000") If you want them to be numbers but formatted as 9 digits, Format/ Cells/ Number: 000000000 [And the word is "digit", not "didget".] -- David Biddulph "Newfie809" wrote in message ... I have an Excel spreadshee with 16000 Employee Numbers. I need to put a Zerro in front of each number to have a nine didget number. It can not go at the back it has to go in front of the number. Is there a formula that would put the number in front of the 8 didget number or do I have to select each cell and add it one by one. Thanks. -- Newfie |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel
Thank you David
I know that the spelling of diget was wrong but I was talking to someone else at my desk and forgot to correct it before I sent it. Thanks -- Newfie "David Biddulph" wrote: If you want to turn them into text strings, either =0&A1 or =TEXT(A1,"000000000") If you want them to be numbers but formatted as 9 digits, Format/ Cells/ Number: 000000000 [And the word is "digit", not "didget".] -- David Biddulph "Newfie809" wrote in message ... I have an Excel spreadshee with 16000 Employee Numbers. I need to put a Zerro in front of each number to have a nine didget number. It can not go at the back it has to go in front of the number. Is there a formula that would put the number in front of the 8 didget number or do I have to select each cell and add it one by one. Thanks. -- Newfie |
#4
|
|||
|
|||
Quote:
assuming first entry is in A1. You can then copy|paste special Values over the original column. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel
-- Newfie "Newfie809" wrote: Thank you David Newfie "David Biddulph" wrote: If you want to turn them into text strings, either =0&A1 or =TEXT(A1,"000000000") If you want them to be numbers but formatted as 9 digits, Format/ Cells/ Number: 000000000 - David Biddulph "Newfie809" wrote in message ... I have an Excel spreadshee with 16000 Employee Numbers. I need to put a Zerro in front of each number to have a nine digit number. It can not go at the back it has to go in front of the number. Is there a formula that would put the number in front of the 8 digit number or do I have to select each cell and add it one by one. Thanks. -- Newfie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|