You might search in Excel on "default workbook" for information on how to
customize the initial workbook when Excel opens.

However a customized initial workbook will not be used when you open a text
file in Excel through File, open. To open a text file into an existing
(pre-formatted) workbook try using Data, Import External Data (as it's
called in Excel 2003, you forgot to mention your version). You have quite a
bit of control over how the data is formatted and where it goes with this
method.

--
Jim
"rbecerra" wrote in
message ...
|
| Regards,
|
| When you start Excel, the new spreadsheets come with default format =
| "General".
|
| I need this default format to be changed to "Text". Following is the
| explanation of the reason I need this:
|
| I work in PLC programming, and usually I use Excel to edit some CSV
| files. Those files contains some numeric fields in decimal format (for
| example 5.5, 5.2, 5.0, 4.0). When I open the CSV file with Excel, the
| program eliminates the decimal part of round numbers (in the example
| given, Excel converts my numbers to 5.5, 5.2, 5, 4).
|
| I really need the round numbers to keep its decimal part (I need 5.0,
| not 5!!!).
|
| And I need it to work when I open my CSV files (please, no posts of
| "you should select the cells and use the format cells option..."
| because when I open my CSV file the damage is performed...).
|
| Any ideas?
|
|
| --
| rbecerra
| ------------------------------------------------------------------------
| rbecerra's Profile:
http://www.excelforum.com/member.php...o&userid=27043
| View this thread: http://www.excelforum.com/showthread...hreadid=459568
|