If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel cell Formatting
I would like to type numbers including leading zeros while still being able
to do calculations. Is this possible? What is the format type? When I use text it allows the leading zero, but of course not calculations can be made on the entries because it is treated as text. Thanks in advance. Scott |
#2
|
|||
|
|||
Excel cell Formatting
I would try a custom number format (Format menu | Cells | Number tab | Custom
format tab. Use a custom format of 00000 (five zeros to guarantee leading zeros appear before all numbers = 99999. Use more or less zeros depending on your application. "Scott" wrote: I would like to type numbers including leading zeros while still being able to do calculations. Is this possible? What is the format type? When I use text it allows the leading zero, but of course not calculations can be made on the entries because it is treated as text. Thanks in advance. Scott |
Thread Tools | |
Display Modes | |
|
|