zero at the beginning of a telephone#

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
Precede your entries with an apostrophe (') or format your cells as
'Text'.

Hope this helps!
 
Format the column, row, cell to Text.

Regards.

Bill Ridgeway
Computer Solutions
 
You must log in or register to reply here.

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

Determining How An Existing Cell Is Formatted ? 4
How Do I Create A Fax Cover Sheet In Word 2002 With Correct Formatting? 6
Excel Macro to automatically go to the right of the last colored cell 0
Zeros if cell is blank 2
Format Numbers 4
How can I keep a zero at the beginning of a mobile number? 3
Numbers left-aligned in a cell 4
How can I click on a telephone number in an Excel 2002 spreadsheet, and have the number dialed? 2

Back
Top