zero at the beginning of a telephone#

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ferdy - 25 May 2005 16:34 GMT

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 to this Message

Domenic - 25 May 2005 16:41 GMT

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

Hope this helps!

> 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 to this Message

Bill Ridgeway - 25 May 2005 17:43 GMT

Format the column, row, cell to Text.

Regards.

Bill Ridgeway
Computer Solutions

> When I type 01243 32186 (telephone number) it is left aligned in the cell
> and
[quoted text clipped - 4 lines]
> 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 to this Message

ferdy - 25 May 2005 18:08 GMT

Domenic, Bill - thank you!!!

> Format the column, row, cell to Text.
>
[quoted text clipped - 11 lines]
> > 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 to this Message