Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
uk pounds
hi i have doing an invoice and want to know how can i change the $ sign to Uk
pounds...the symbol? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Phone Numbers Repeated | Excel Discussion (Misc queries) | |||
How can I cross reference phone numbers with existing phone numbe. | Excel Discussion (Misc queries) | |||
How to insert a repeating dash in phone numbers without dashes in. | New Users to Excel | |||
I Need a Formula to Auto-fill Phone Numbers in a Range | Excel Worksheet Functions | |||
Phone Numbers | Excel Worksheet Functions |