Menu

Disable auto-formatting dates.... GRRR!

Search this Thread

#1

Report Post

Posted to microsoft.public.mac.office.excel,microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc

JE McGimpsey

Posts: n/a

Default

Disable auto-formatting dates.... GRRR!

In article .com,
wrote:

I have even tried to create a new "book.xlt" and put it in the
App/MSO2004/Startup/Excel directory with all fields set as "Text"
instead of "General" and it works great as long as I start with a blank
SS, but if I go to "Open" my file, it still converts that darn date
field.

If you open it using the Text import wizard (or choose Data/Get External
Data/Import Text file...), the third pane of the wizard's dialog allows
you to set any field to Text.

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting (Dates) Repost with additional data	BigH	Excel Discussion (Misc queries)	1	January 29th 06 10:18 PM
Track Annual Inspection Due Dates Using Conditional Formatting	Scatman	Excel Worksheet Functions	3	December 7th 05 02:44 PM
How do I disable automatic date formatting in excel?	tcuneio	Excel Discussion (Misc queries)	1	January 21st 05 10:47 PM
Auto Formatting an Excel Spreadsheet	Ray	Excel Discussion (Misc queries)	0	January 19th 05 09:57 PM
Response to Frank: AM-PM Auto formatting	BulaMan	Excel Discussion (Misc queries)	2	December 15th 04 10:26 AM

All times are GMT +1. The time now is 02:17 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement