why does the 0 dissapear when i start a telephone no with 0

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tash - 04 Dec 2007 14:08 GMT

I am keeping a list of account numbers and sort codes, but every time i type
a number beginning with a 0 it is auto removed!!

Reply to this Message

Soundar - 04 Dec 2007 14:14 GMT

Hi,

Before typing the number beginning with zero, convert that cell format to
text (Format--> Cells-->Number--> select Text in the list) otherwise begin
with ' (single quote) and then type the number ('012345).

Hope this will clear your doubt.

Regards,
Soundar.

> I am keeping a list of account numbers and sort codes, but every time i type
> a number beginning with a 0 it is auto removed!!

Reply to this Message

Bob Phillips - 04 Dec 2007 14:47 GMT

Format your cell as 000000

or however many you need.

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>I am keeping a list of account numbers and sort codes, but every time i
>type
> a number beginning with a 0 it is auto removed!!

Reply to this Message

P D Sterling - 05 Dec 2007 12:20 GMT

I am guessing that you are in the UK or somewhere where phone numbers do
begin with zero. I wish Uncle Bob would realize that phone numbers are
actually not calculable, and are, therefore, codes, and should be
allowed to be texted. just as area codes are CODES, formatted to be all
numeric. duh!!

Regards,

P D Sterling
New York, Texas & Texas, New York

> I am keeping a list of account numbers and sort codes, but every time i type
> a number beginning with a 0 it is auto removed!!

Reply to this Message