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? |
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? |
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? |
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? |
All times are GMT +1. The time now is 04:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com