Home |
Search |
Today's Posts |
#1
|
|||
|
|||
numeric format
Is there a way to set the default numeric format so that 0s in front of
the number show in the cells? E.g., if I input 0033421, the cell shows 33421 UNLESS I put an apostrophe in front of it, as in '0033421. I'd like to skip the apostrophe if possible. |
#2
|
|||
|
|||
"Rocket J Squirrel" wrote:
Is there a way to set the default numeric format so that 0s in front of the number show in the cells? E.g., if I input 0033421, the cell shows 33421 UNLESS I put an apostrophe in front of it, as in '0033421. I'd like to skip the apostrophe if possible. Select FormatCells and go to NumberCategoryCustom then clear the Type field and enter some 0's and watch what happens to the sample. When it displays what you want to see, click OK |
#3
|
|||
|
|||
bigwheel wrote:
"Rocket J Squirrel" wrote: Is there a way to set the default numeric format so that 0s in front of the number show in the cells? E.g., if I input 0033421, the cell shows 33421 UNLESS I put an apostrophe in front of it, as in '0033421. I'd like to skip the apostrophe if possible. Select FormatCells and go to NumberCategoryCustom then clear the Type field and enter some 0's and watch what happens to the sample. When it displays what you want to see, click OK Thanx. I'll try it tommorrow. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
protecting format | Excel Discussion (Misc queries) | |||
Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) | |||
Text to Numeric format | Excel Discussion (Misc queries) |