Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enter NUMBERS with leading zeros In Excel ie 001, 002 ?
see subject. I am using Office 2003 and wish to log series of 3 - 5 digit
serial numbers and also record similar numbers in randonm order but excel persists in deleting leading zeros unless I enter the figures as as text. Thanks. |
#2
|
|||
|
|||
Answer: How do I enter NUMBERS with leading zeros In Excel ie 001, 002 ?
To enter numbers with leading zeros in Excel:
To add leading zeros to numbers that have already been entered:
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enter NUMBERS with leading zeros In Excel ie 001, 002 ?
A "number" with a leading zero IS text, not a real number. Entering it as
TextFormat will preserve it's state. If you want to enter a "real number" and make it look like it has a leading zero, that can be done with Custom Formatting. hth Vaya con Dios, Chuck, CABGx3 "bobl3517" wrote: see subject. I am using Office 2003 and wish to log series of 3 - 5 digit serial numbers and also record similar numbers in randonm order but excel persists in deleting leading zeros unless I enter the figures as as text. Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enter NUMBERS with leading zeros In Excel ie 001, 002 ?
On Tue, 29 Aug 2006 06:15:02 -0700, bobl3517
wrote: see subject. I am using Office 2003 and wish to log series of 3 - 5 digit serial numbers and also record similar numbers in randonm order but excel persists in deleting leading zeros unless I enter the figures as as text. Thanks. You must either enter them as text or custom format the cell. For example, Format/Cells/Number/Custom Type: "000" or "00000" If you custom format the cells as above, you will not need to enter the leading zero's. If you want to enter a variable number of leading zeros, unless there is some method of determining the correct number of leading zero's, you will have to enter as text. --ron |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enter NUMBERS with leading zeros In Excel ie 001, 002
Thanks Ron, I tried many ways and got close in CUSTOM but entering 000
without the " " works fine. Cheers, Bob. "Ron Rosenfeld" wrote: On Tue, 29 Aug 2006 06:15:02 -0700, bobl3517 wrote: see subject. I am using Office 2003 and wish to log series of 3 - 5 digit serial numbers and also record similar numbers in randonm order but excel persists in deleting leading zeros unless I enter the figures as as text. Thanks. You must either enter them as text or custom format the cell. For example, Format/Cells/Number/Custom Type: "000" or "00000" If you custom format the cells as above, you will not need to enter the leading zero's. If you want to enter a variable number of leading zeros, unless there is some method of determining the correct number of leading zero's, you will have to enter as text. --ron |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enter NUMBERS with leading zeros In Excel ie 001, 002
Thanks Chuck, I had tried CUSTOMising but Ron gave me the right clue but it
only works without the " " quotes. Cheers, Bob. "CLR" wrote: A "number" with a leading zero IS text, not a real number. Entering it as TextFormat will preserve it's state. If you want to enter a "real number" and make it look like it has a leading zero, that can be done with Custom Formatting. hth Vaya con Dios, Chuck, CABGx3 "bobl3517" wrote: see subject. I am using Office 2003 and wish to log series of 3 - 5 digit serial numbers and also record similar numbers in randonm order but excel persists in deleting leading zeros unless I enter the figures as as text. Thanks. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enter NUMBERS with leading zeros In Excel ie 001, 002
On Tue, 29 Aug 2006 06:46:02 -0700, bobl3517
wrote: Thanks Ron, I tried many ways and got close in CUSTOM but entering 000 without the " " works fine. Cheers, Bob. Sorry for the Quote confusion. You are correct in that you should be omitting the quote marks. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel how do I get 2 zeros to show automatically after I enter. | Excel Discussion (Misc queries) | |||
HOW DO I ENTER ROMAN NUMBERS INTO EXCEL | Excel Worksheet Functions | |||
How to remove leading zeros using excel 2000 | Excel Discussion (Misc queries) | |||
How to suppress leading zeros in Excel | Excel Discussion (Misc queries) | |||
How do I enter a decimal in a string of numbers in Excel? Example. | Excel Discussion (Misc queries) |