LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.mac.office.excel,microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc
 
Posts: n/a
Default Disable auto-formatting dates.... GRRR!

I have a large tab delimited file that I am opening in Word, it has two
date cells that are for dates, but they are in format YYYY-MM-DD
HH:MM:SS, and everytime I open it in Excel, it converts those fields to
dates, I need them to stay in their current format (text).

When I highlight the field and change it back to text, it converts all
the dates to a crazy number. I can't find the option anywhere to
turn-off "auto-date"...

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.

HELP!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 04:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"