The telephone format for Excel 2003 is incorrect

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I cannot get the telephone format under special formatting for cells to work
in
Excel 2003. I have it set for US and have tried the same formatting in
Custom. Both return a number something like this: (3) 60-8744 when I input
3608744444. Any help?
 
WildBills said:
I cannot get the telephone format under special formatting for cells to work
in
Excel 2003. I have it set for US and have tried the same formatting in
Custom. Both return a number something like this: (3) 60-8744 when I input
3608744444. Any help?
Click to expand...

you should make user format settings in cells like ???-???-????
if you input 3608744444 in cell 360-874-4444. pls try.
sorry my poor english
tks
 
mitsuru said:
you should make user format settings in cells like ???-???-????
if you input 3608744444 in cell 360-874-4444. pls try.
sorry my poor english
tks
Click to expand...

or other settings
(0??) ???-???? -> input 0123456789 then (012) 345-6789
(000) 000-0000 -> input 123456789 then (012) 345-6789
 
mitsuru said:
[quoted text clipped - 6 lines]
sorry my poor english
tks
Click to expand...

or other settings
(0??) ???-???? -> input 0123456789 then (012) 345-6789
(000) 000-0000 -> input 123456789 then (012) 345-6789
Click to expand...

think its more perfect
(?00) 000-0000 -> input 123456789 then ( 12) 345-6789
or
?00-000-0000 -> input 123456789 then 12-345-6789
?00-000-0000 -> input 0123456789 then 012-345-6789

tks n goodLuck
by mitsuru from okinawa japan
 
Back
Top