Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Number formatting when importing from Access to Excel
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 |
#2
|
|||
|
|||
Alicia,
Select the cells then... Format | Cells | Number (tab) | Special | Phone number Regards, Jim Cone San Francisco, USA | "Alicia Rittenhouse" wrote in message 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Phone Number Formatting | Excel Discussion (Misc queries) | |||
How do I do conditional formatting on number formats not patterns. | Excel Discussion (Misc queries) | |||
Number formatting | Excel Discussion (Misc queries) | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |