Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to display the number zero at the beginning of a number when .
-- Cal |
#2
|
|||
|
|||
Type an apostrophe before the leading zero.........the apostrophe will not
display, but will convert the cell to TEXT format.....or, format the cell as TEXT before entering the number with the leading zero. Vaya con Dios, Chuck, CABGx2 "Calvin" wrote in message ... -- Cal |
#3
|
|||
|
|||
Another option to try ..
You could also format the column to display the leading zeros as desired Example: Select col A Format Cells Number tab Select Custom under Category In the "Type:" box, enter (say): 0000 Click OK Test it out by entering a couple of numbers in col A Entering: 12 will display as 0012 1 as 0001 900 as 0900 123 as 0123 and so on -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get the zeros to show up in the beginning of a number? | Excel Discussion (Misc queries) | |||
In Excel how can a number automatically display in text form | Excel Worksheet Functions | |||
How do I display an insignificant 0 at the beginning of a number | Excel Discussion (Misc queries) | |||
How do I multiply Column G Totals by a number and display the res. | Excel Discussion (Misc queries) | |||
only include cells beginning with specified character or number | Excel Worksheet Functions |