Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
When I place a telephone number begining with zero into a cell, as soon as I move away from that cell, the zero at the begining of the telephone number disapears. I have tried formatting the cell for text, which does allow the zero to remain but it also puts a green tag in the top left of the cell. I have also tried the other formats but I just can't seem to get the zero to stay put. Any suggestions would be appreciated. Regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I change format of page numbers to letters in Excel? | Excel Discussion (Misc queries) | |||
cell format in Excel 2002 SP3 will not accept long numbers | Excel Worksheet Functions | |||
Conditional format numbers | Excel Worksheet Functions | |||
Using Replace to Format Negative Numbers | Excel Discussion (Misc queries) | |||
Cell will not format numbers correctly for a 13 digit custom barc. | Excel Worksheet Functions |