Australian Telephone Numbers

A

Alan Cocks

Australian local telephone numbers are eight digits written in two groups of
four with a space between. Formatted as 0000 0000 or #### ####.
Office XP won't allow me to use either of these formats. They keep
reverting to 00 000 000 or ## ### ###.
Any ideas on how to correct this?
Alan
 
N

Norman Harker

Hi Alan!

Why use numbers? Why not pre-format the cells as text?

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
E

Ed Ferrero

Hi Alan,

Don't have a copy of Office XP here to try this on, but try using a more
explicit format like
0000\ 0000
or perhaps
#_#####

Also, check the Regional Options in Control Panel. Is your digit grouping a
comma or a space?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I convert nnnnnnnnnn to nnn nnn nnnn (Telephone numbers)? 5
Formating advanced numbers 2
Column Of Numbers To A Text Format Problem 1
changing the Phone Number Input Mask to all for extensions 2
Text formatting 4
search telephone numbers in outlook 2007 13
Customize telephone number format in Outlook 1
Adding a space inbetween letters and numbers in a cell 2

Top