View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve
 
Posts: n/a
Default Formatting Phone Numbers in a Merged Cells...


If I want to merge a "Company Name", "Phone Number" and a "Fax" number into
1 cell (for use in a drop down box), is there a way to maintain the 10 digit
format for the phone/fax numbers?

The phone/fax #'s appear as a string of 10 digits when they are merged, and
are hard to read.

Currently using a formula like this: =A3&" Phone: "&B3&" Fax: "&C3

I am tired of trying to get it to work, and can't seem to find the answer
here.

Thank you in advance!