| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to display zero prefixes in worksheet cells such as phone numb
I want to know how to display a phone number with a zero prefix or a series
of digits with a prefix of zero e.g 0427. When I input 0427 the cell shows 427. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to display zero prefixes in worksheet cells such as phone numb
Format the cells to 0000. Right clickFormat CellsFrom the list select
'Custom' and enter 0000 in Type field. This will make sure the number you enter is always displayed as 4 digits.. -- Jacob "bomber bob" wrote: I want to know how to display a phone number with a zero prefix or a series of digits with a prefix of zero e.g 0427. When I input 0427 the cell shows 427. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Separating prefixes in names | Excel Discussion (Misc queries) | |||
| Count a number in a range with cells containing more than one numb | Excel Worksheet Functions | |||
| display USA phone format in formula bar | Excel Discussion (Misc queries) | |||
| Worksheet function to retrieve cell value based on row an col numb | Excel Discussion (Misc queries) | |||
| How do I sum up only the numbers in cells containing text and numb | Excel Discussion (Misc queries) | |||
Hybrid Mode
