Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I make 041960 appear like 041960 instead of 41960?
I am typing in 041960 and it is making it automatically change to 41960. How
can I stop this so the data appears as 041960? |
#2
|
|||
|
|||
Hi Gordiva
Format the cell as 000000 This is how you can do it: Right click the cell and select format. In the pop up window in the number tab you have a list of various formats. Select "custom" at the end of the list. Once you select custom you get a list of custom formats and you will see a text box just below "Type" which would show "General" by default. Replace this with 000000 ( zero 6 times) and click OK.. And what you get is the number in the required format. Thanks Karthik bhat Bangalore |
#3
|
|||
|
|||
You need to create a custom number format. Format -- Cells, on the Number
Tab, select Custom. The select the ) Type and edit it to 000000. That will force the leading zero to appear. You can also start your entry with an apostrophe (e.g., '041960) and then it will appear with the leading zero. Excel will treat cell entries with a leading apostrophe as text rather than as a number, so keep that in mind if you need to do any calculations with the entries. -- Elisabeth "Gordiva" wrote: I am typing in 041960 and it is making it automatically change to 41960. How can I stop this so the data appears as 041960? |
#4
|
|||
|
|||
format it as text
"Gordiva" wrote: I am typing in 041960 and it is making it automatically change to 41960. How can I stop this so the data appears as 041960? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make a timesheet to figure my hours and payrate? | Excel Worksheet Functions | |||
Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? | New Users to Excel | |||
how do I make make my hyperlinks show the email address they are . | Excel Discussion (Misc queries) | |||
make hidden window or workbook visible without specify the name | Excel Worksheet Functions | |||
make a cell empty based on condition | Charts and Charting in Excel |