Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I display zeros in excel if they are the beginning characte
This is what I did according to the excel help menu:
Display or hide all zero values on a worksheet On the Tools menu, click Options, and then click the View tab. Do one of the following: To display zero (0) values in cells, select the Zero values check box. This did not work. The preceeding zero's are necessary for record keeping. Appreciate any help given. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I display zeros in excel if they are the beginning characte
Hi
If it's a number, use a custom format of 000000 or whatever. The alternative is to format the cell as text first. Hope this helps. Andy. "marchnelson" wrote in message ... This is what I did according to the excel help menu: Display or hide all zero values on a worksheet On the Tools menu, click Options, and then click the View tab. Do one of the following: To display zero (0) values in cells, select the Zero values check box. This did not work. The preceeding zero's are necessary for record keeping. Appreciate any help given. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I display zeros in excel if they are the beginning characte
You could conditionally format the targeted cells: FormatConditional Formatting Then do 'Cell Value' : 'Is Equal To' : 0 Then choose white, hence hiding your zeroes. SamuelT -- SamuelT ------------------------------------------------------------------------ SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501 View this thread: http://www.excelforum.com/showthread...hreadid=545488 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I display zeros in excel if they are the beginning characte
Leading zeros in front of a "number" indicate that the value is actually
TEXT, not a number at all. If you type 01234 in a cell formatted for a number, or General, the leading zero will dissappear and the value will become a true "number". To keep the leading zero in place, first format the cell for TEXT, or type an apostrophe in front of the first zero. This will automatically Format that cell as TEXT, and the apostrophe will not show in the cell or on printouts, only in the formula bar. hth Vaya con Dios, Chuck, CABGx3 "marchnelson" wrote: This is what I did according to the excel help menu: Display or hide all zero values on a worksheet On the Tools menu, click Options, and then click the View tab. Do one of the following: To display zero (0) values in cells, select the Zero values check box. This did not work. The preceeding zero's are necessary for record keeping. Appreciate any help given. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Stop Excel from dropping the 0 in the beginning of a number | Setting up and Configuration of Excel | |||
How can I display numbers beginning with zero? | Excel Discussion (Misc queries) | |||
How do I force leading zeros in an Excel cell? | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |