Home |
Search |
Today's Posts |
#1
|
|||
|
|||
zero at the beginning of a telephone#
When I type 01243 32186 (telephone number) it is left aligned in the cell and
exactly as it is typed. As soon as I move the cursor away from that cell, the telephone number flies across to the right in the cell and the '0' disappears so it reads 1243 32186 and is right aligned in the cell. As the data is to be used as a database I am using General cell formatting. Can anyone help me please to sort out these irritating jumping numbers? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas for telephone numbers: finding duplicates, autoformat | Excel Worksheet Functions | |||
Format the Cell into a telephone number but using country code | Excel Discussion (Misc queries) | |||
Telephone number format | Excel Discussion (Misc queries) | |||
How do i insert information into the beginning of every field? | Excel Discussion (Misc queries) | |||
only include cells beginning with specified character or number | Excel Worksheet Functions |