zero at the beginning of a telephone#

G

Guest

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?
 
D

Domenic

Precede your entries with an apostrophe (') or format your cells as
'Text'.

Hope this helps!
 
B

Bill Ridgeway

Format the column, row, cell to Text.

Regards.

Bill Ridgeway
Computer Solutions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format Numbers 4
Addiing a Zero to a number which is already there 1
Viewing Zero's In Cells 8
number format keeps dividing by 100 2
How to enter zip starting with 0 (zero) 10
data entry problems in excel 1
Sorting Problem 1
number format 1

Top