Home |
Search |
Today's Posts |
#1
|
|||
|
|||
In excel how do you format so 09561 for example the zero does not.
doing worksheet for ordering zeros at beginning of numbers disappear. How do
I format to keep zero in group of numbers ie 04581 |
#2
|
|||
|
|||
FormatCellsNumberCustom In the Type box, enter 00000
-- Kind Regards, Niek Otten Microsoft MVP - Excel "spoggy" wrote in message ... doing worksheet for ordering zeros at beginning of numbers disappear. How do I format to keep zero in group of numbers ie 04581 |
#3
|
|||
|
|||
hi,
numbers with leading zeros should be entered as text. when entering the number, enter an apostrophe first. like this '04581. excel will hide the apostrophe and keep the leading zero. you could enter a custom format to force excel to show a zero but this would only show a zero in the cell. in the formula bar, the zero would not be there. in other words, formating does not change the data. it changes the way it looks on screen. -----Original Message----- doing worksheet for ordering zeros at beginning of numbers disappear. How do I format to keep zero in group of numbers ie 04581 . |
#4
|
|||
|
|||
Better than a custom number format, and also better than a laeding
apostrophe, is to format the cells as Text. After selecting the cells you want treated this way, use the menu to choose Format | Cells | Number & from the left hand panel (Category) choose Text & click on OK. Once you've done that, you can freely enter leading zeros without the need to use an initial apostrophe "spoggy" wrote: doing worksheet for ordering zeros at beginning of numbers disappear. How do I format to keep zero in group of numbers ie 04581 |
#5
|
|||
|
|||
If you have a whole column to enter that way, then just highlight the
column, Format Cells NumberTab Text OK.........this way you don't have to remember to type the leading apostrophe each time, nor do your users........ Vaya con Dios, Chuck, CABGx3 "spoggy" wrote in message ... doing worksheet for ordering zeros at beginning of numbers disappear. How do I format to keep zero in group of numbers ie 04581 |
#6
|
|||
|
|||
Duke Carey, Thanx. I needed help in this area as I am new to Excel 2003. I am writing a data worksheet displaying binary, hexadecimal, and decimal numbers. I read your reply and you made my day. -- ill ------------------------------------------------------------------------ ill's Profile: http://www.excelforum.com/member.php...o&userid=24789 View this thread: http://www.excelforum.com/showthread...hreadid=357449 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change the excel format from language to language? | Excel Discussion (Misc queries) | |||
How do I unhide the cell format function in Excel 2000 | Excel Worksheet Functions | |||
USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
Excel Number Format | Excel Discussion (Misc queries) | |||
Import Indian Rupees as a number format in Excel | Excel Discussion (Misc queries) |