software

Hi

When I place a telephone number begining with zero into a cell, as soon as I
move away from that cell, the zero at the begining of the telephone number
disapears.

I have tried formatting the cell for text, which does allow the zero to
remain but it also puts a green tag in the top left of the cell. I have also
tried the other formats but I just can't seem to get the zero to stay put.

Any suggestions would be appreciated.

Regards

Precede the number with a single quote (apostrophe)
--
Gary''s Studentquot;chesjakquot; wrote:

gt; Hi
gt;
gt; When I place a telephone number begining with zero into a cell, as soon as I
gt; move away from that cell, the zero at the begining of the telephone number
gt; disapears.
gt;
gt; I have tried formatting the cell for text, which does allow the zero to
gt; remain but it also puts a green tag in the top left of the cell. I have also
gt; tried the other formats but I just can't seem to get the zero to stay put.
gt;
gt; Any suggestions would be appreciated.
gt;
gt; Regards

Hi Gary

Thanks for your reply but are you sure that that is necessary. In other
excel spreadsheets that I am sent, the zero in front of the telephone numbers
do not have an apostrophe in front of them. can it not be a matter of
correct formating of the cells??

Regards

quot;Gary''s Studentquot; wrote:

gt; Precede the number with a single quote (apostrophe)
gt; --
gt; Gary''s Student
gt;
gt;
gt; quot;chesjakquot; wrote:
gt;
gt; gt; Hi
gt; gt;
gt; gt; When I place a telephone number begining with zero into a cell, as soon as I
gt; gt; move away from that cell, the zero at the begining of the telephone number
gt; gt; disapears.
gt; gt;
gt; gt; I have tried formatting the cell for text, which does allow the zero to
gt; gt; remain but it also puts a green tag in the top left of the cell. I have also
gt; gt; tried the other formats but I just can't seem to get the zero to stay put.
gt; gt;
gt; gt; Any suggestions would be appreciated.
gt; gt;
gt; gt; Regards

Hi,

Try and apply a custom number format to the cell.
Select the cell(s), Format, Cells..
On the Number tab, Select Custom under Category
Set the format to 00000000 (Or however many characters your number is)

You can read up custom number formats in Excel's help.

Hope this is what you were looking for.

Seanquot;chesjakquot; gt; wrote in message
...
gt; Hi
gt;
gt; When I place a telephone number begining with zero into a cell, as soon as
gt; I
gt; move away from that cell, the zero at the begining of the telephone number
gt; disapears.
gt;
gt; I have tried formatting the cell for text, which does allow the zero to
gt; remain but it also puts a green tag in the top left of the cell. I have
gt; also
gt; tried the other formats but I just can't seem to get the zero to stay put.
gt;
gt; Any suggestions would be appreciated.
gt;
gt; Regards
Hi Sean

Yes, that's just what I was looking for.

Why didn't I realise it????

Many thanks
==============================

quot;Seanquot; wrote:

gt; Hi,
gt;
gt; Try and apply a custom number format to the cell.
gt; Select the cell(s), Format, Cells..
gt; On the Number tab, Select Custom under Category
gt; Set the format to 00000000 (Or however many characters your number is)
gt;
gt; You can read up custom number formats in Excel's help.
gt;
gt; Hope this is what you were looking for.
gt;
gt; Sean
gt;
gt;
gt; quot;chesjakquot; gt; wrote in message
gt; ...
gt; gt; Hi
gt; gt;
gt; gt; When I place a telephone number begining with zero into a cell, as soon as
gt; gt; I
gt; gt; move away from that cell, the zero at the begining of the telephone number
gt; gt; disapears.
gt; gt;
gt; gt; I have tried formatting the cell for text, which does allow the zero to
gt; gt; remain but it also puts a green tag in the top left of the cell. I have
gt; gt; also
gt; gt; tried the other formats but I just can't seem to get the zero to stay put.
gt; gt;
gt; gt; Any suggestions would be appreciated.
gt; gt;
gt; gt; Regards
gt;
gt;
gt;