phone numbers
 

Sorry I am being a bit thick but I cannot convert my phone numbers to
dialable numbers ie I cannot get the cell to show leading zeros eg 0044 ####
####.
I can format the cells if I go to English (US) but that of course is no good
to me in the UK!
Help!

You can either format the cells as text before you enter the number, or
prefix the number with a ' , like '00855419871. The ' will display on the
formula bar but not in the cell,
Regards,
Alan.
"Tony R" <Tony wrote in message
...
Sorry I am being a bit thick but I cannot convert my phone numbers to
dialable numbers ie I cannot get the cell to show leading zeros eg 0044
####
####.
I can format the cells if I go to English (US) but that of course is no
good
to me in the UK!
Help!

Use 0 (zeros) instead of numeric pound signs if you want to ensure
that you have a digits in the position. See formatting in help.
For instance under formatting you will see special formatting has
one for telephone numbers.

One of the best ways to learn about formatting is to select a format
that comes closest to what you want and then look at it in Custom
Format.

I would really suggest, if possible that entries of phone numbers are
best done in text, then you are not restricted and can type in international
numbers, include extensions etc.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Alan" wrote in message ...
You can either format the cells as text before you enter the number, or
prefix the number with a ' , like '00855419871. The ' will display on the
formula bar but not in the cell,
Regards,
Alan.
"Tony R" <Tony wrote in message
...
Sorry I am being a bit thick but I cannot convert my phone numbers to
dialable numbers ie I cannot get the cell to show leading zeros eg 0044
####
####.
I can format the cells if I go to English (US) but that of course is no
good
to me in the UK!
Help!

uk pounds
 

hi i have doing an invoice and want to know how can i change the $ sign to Uk
pounds...the symbol?

uk pounds
 

FormatCellsCurrency, and select £ from the Symbol dropdown.

--
HTH

Bob

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

"jen coglin" wrote in message
...
hi i have doing an invoice and want to know how can i change the $ sign to
Uk
pounds...the symbol?