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? |
#2
|
|||
|
|||
Precede your entries with an apostrophe (') or format your cells as
'Text'. Hope this helps! In article , "ferdy" wrote: 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? |
#3
|
|||
|
|||
Format the column, row, cell to Text.
Regards. Bill Ridgeway Computer Solutions "ferdy" wrote in message ... 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? |
#4
|
|||
|
|||
Domenic, Bill - thank you!!!
"Bill Ridgeway" wrote: Format the column, row, cell to Text. Regards. Bill Ridgeway Computer Solutions "ferdy" wrote in message ... 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? |
Reply |
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 |