Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
epxort to excel removes trailing 0's
Hi!
The problem is that when exporting data to Excel thinks thant "0000123" is a number. How to tell Excel that this field is text? Is there any way to call the import wizard during exporting to Excel? That would let user select which columns contain text. Inserting ' behind all fields is not good. Thanks, Rommi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
epxort to excel removes trailing 0's
you can put all the data in one column, then let the user do Data=Text to
columns which will bring up the import wizard. -- Regards, Tom Ogilvy "Rommi Saar" wrote in message ... Hi! The problem is that when exporting data to Excel thinks thant "0000123" is a number. How to tell Excel that this field is text? Is there any way to call the import wizard during exporting to Excel? That would let user select which columns contain text. Inserting ' behind all fields is not good. Thanks, Rommi |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
epxort to excel removes trailing 0's
I'm currently using something like that:
ShellExecute(0,'open','excel',PChar('filename.txt" '),nil,SW_SHOWNORMAL); "Rommi Saar" wrote in message ... Hi! The problem is that when exporting data to Excel thinks thant "0000123" is a number. How to tell Excel that this field is text? Is there any way to call the import wizard during exporting to Excel? That would let user select which columns contain text. Inserting ' behind all fields is not good. Thanks, Rommi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save as .csv file removes trailing 00 | Excel Discussion (Misc queries) | |||
Save as .csv file removes trailing 00 | Excel Discussion (Misc queries) | |||
Excel XP removes AS part of statement | Excel Programming | |||
Excel XP removes AS part of statement | Excel Programming | |||
Excel XP removes AS part of statement | Excel Programming |