Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how can i get a cell to hold a zero in front of a digit ie. 01 or.
I have tried checking the zero values box but still just takes the zero from
the front which I need for the table I am trying to plan. I don't want any decimal points in front |
#2
|
|||
|
|||
You can do it three ways
1) If the 'number' you want to end up with is fixed length, say six characters, then FormatCells...Custom000000 will do it 2) Format the cells as text in advance of entry 3) Prefix with a single apostrophe ('). It will not show but will treat the entry as text -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Southern Belle" <Southern wrote in message ... I have tried checking the zero values box but still just takes the zero from the front which I need for the table I am trying to plan. I don't want any decimal points in front |
#3
|
|||
|
|||
Use a custom numeric format like 00 or precede entry with an apostrophe or
format as text before you enter it Regards, Peo Sjoblom "Southern Belle" <Southern wrote in message ... I have tried checking the zero values box but still just takes the zero from the front which I need for the table I am trying to plan. I don't want any decimal points in front |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |