View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alicia Rittenhouse Alicia Rittenhouse is offline
external usenet poster
 
Posts: 10
Default Number formatting when importing to Excel from Access

I have been trying to import phone numbers and date of births from Access
into Excel. When I do this the numbers loose all of their formatting. I
can't even use Excel's formatting to change the way the numbers look. I
figured out how to do it in Word so I know that there has to be a way to do
this.

What it looks like before I import
(123) 567-8910

When I get it in Excel
12345678910

PLEASE HELP!!!!

Thanks!!!! Alicia Rittenhouse