| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I import from csv file without auto formatting?
I want to import a csv file into Excel without having Excel automatically
formatting the values. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I import from csv file without auto formatting?
Read it in not by double clicking or by File/ Open, but instead use Excel's
Data/ Import External Data. Then choose appropriate format (probably text) for each column. -- David Biddulph "zvikam" wrote in message ... I want to import a csv file into Excel without having Excel automatically formatting the values. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I import from csv file without auto formatting?
Can I automate this? I want it always to open csv files treating all values
as text without the need to configure this setting through this wizard each time. Thanks, Zvika. "David Biddulph" wrote: Read it in not by double clicking or by File/ Open, but instead use Excel's Data/ Import External Data. Then choose appropriate format (probably text) for each column. -- David Biddulph "zvikam" wrote in message ... I want to import a csv file into Excel without having Excel automatically formatting the values. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I import from csv file without auto formatting?
Change the extension of your csv files to .txt.
-- David Biddulph "zvikam" wrote in message ... Can I automate this? I want it always to open csv files treating all values as text without the need to configure this setting through this wizard each time. Thanks, Zvika. "David Biddulph" wrote: Read it in not by double clicking or by File/ Open, but instead use Excel's Data/ Import External Data. Then choose appropriate format (probably text) for each column. -- David Biddulph "zvikam" wrote in message ... I want to import a csv file into Excel without having Excel automatically formatting the values. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I import from csv file without auto formatting?
Maybe you could use:
Data|Import external data| (in xl2003 menus) zvikam wrote: I want to import a csv file into Excel without having Excel automatically formatting the values. -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I import from csv file without auto formatting?
Hmmm, doesn't seem to work.
If it's comma separated, once I open it in Excel, it puts the entire row in one cell as one big string. If it's tab separated, it does the same auto formatting. Sad. "David Biddulph" wrote: Change the extension of your csv files to .txt. -- David Biddulph "zvikam" wrote in message ... Can I automate this? I want it always to open csv files treating all values as text without the need to configure this setting through this wizard each time. Thanks, Zvika. "David Biddulph" wrote: Read it in not by double clicking or by File/ Open, but instead use Excel's Data/ Import External Data. Then choose appropriate format (probably text) for each column. -- David Biddulph "zvikam" wrote in message ... I want to import a csv file into Excel without having Excel automatically formatting the values. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto-import csv into Excel? | Excel Discussion (Misc queries) | |||
| How come I can't import an .svc file(Open Office) to Excel file? | Excel Discussion (Misc queries) | |||
| Would Like to Automate Batch File Creation and Text FIle Import | Excel Discussion (Misc queries) | |||
| Auto-Import and sort data in Excel | Excel Worksheet Functions | |||
| Auto Import OR Searching TXT Data | Excel Worksheet Functions | |||
Linear Mode
