Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number formatting when importing to Excel from Access
If you format the cell using the special telephone number format, the
appearance doesn't change? If so, the the numbers are being stored as text. You can select the column and format as general, then do Data=Text to Columns, select delimited and select comma as the delimiter. This should cause the numbers to be reevaluated by excel and restored as numbers. Then you can format the column with the Telephone Number format. -- Regards, Tom Ogilvy "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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number formatting when importing to Excel from Access
Thank You so much!!!! This worked perfectly!!!
"Tom Ogilvy" wrote: If you format the cell using the special telephone number format, the appearance doesn't change? If so, the the numbers are being stored as text. You can select the column and format as general, then do Data=Text to Columns, select delimited and select comma as the delimiter. This should cause the numbers to be reevaluated by excel and restored as numbers. Then you can format the column with the Telephone Number format. -- Regards, Tom Ogilvy "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 | |||
Formatting Cells for Importing into Access | Setting up and Configuration of Excel | |||
Number formatting when importing from Access to Excel | Excel Discussion (Misc queries) | |||
Importing to access from excel | Excel Discussion (Misc queries) | |||
Importing Access mdb to Excel | Excel Programming | |||
Importing Access Data and formatting it in Excel....! | Excel Programming |