| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 92959 | 2008-08-29 07:29:00 | Cell phone number display in Excel | Colpol (444) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 701265 | 2008-08-29 07:29:00 | How do I get Excel to display the zero at the start of a cell phone number. Have tried all the formats but all delete the zero when I click OK I have done this before but can't remember how to do it. Cheers Colin |
Colpol (444) | ||
| 701266 | 2008-08-29 07:32:00 | Formatting the cells as "Text" will leave any zeros in place. | stormdragon (6013) | ||
| 701267 | 2008-08-29 07:34:00 | Thank you:) : Found the answer. If you make it Text it comes up with error(which you can ignore). Found that if you put spaces in the number it leaves the zero in place(No Error) |
Colpol (444) | ||
| 701268 | 2008-08-29 07:44:00 | No probs | stormdragon (6013) | ||
| 1 | |||||