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
Disable auto-formatting dates.... GRRR! [email protected] Excel Discussion (Misc queries) 2 February 2nd 06 01:22 PM
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
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 05:40 PM.

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

About Us

"It's about Microsoft Excel"