Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format when opening .CSV file in Excel
Hello:
We are creating .CSV file( comma delieminated) from the Web Page so that users can use Excel to view the file. The issue is with format. We like the data to be left formatted. Also like Excel NOT to drop leading zeros. Can this be done using .CSV format? If not what options we have |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format when opening .CSV file in Excel
Mohan wrote:
We are creating .CSV file( comma delieminated) from the Web Page so that users can use Excel to view the file. The issue is with format. We like the data to be left formatted. Also like Excel NOT to drop leading zeros. Can this be done using .CSV format? If not what options we have If the file extension is CSV, Excel gives you no options. If the file extension is something else, Excel will show the Text Import wizard; you can specify certain columns to be treated as text, which should preserve the leading zeros. Left alignment would need to be done by a macro after the import. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - reply in newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date format problem from opening dbf file in excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 File Problems (Opening New Format) | Excel Discussion (Misc queries) | |||
opening csv file in regular excel format | Excel Discussion (Misc queries) | |||
How to use the exact format in a csv file when opening a csv file | Excel Discussion (Misc queries) | |||
Excel getting Error - file format is not valid WHEN OPENING | Excel Discussion (Misc queries) |