Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.mac.office.excel,microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.mac.office.excel,microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc
|
|||
|
|||
Disable auto-formatting dates.... GRRR!
If the file is a .txt file then when you do File | Open Excel will
automatically take you through the Text Import Wizard. Here you can specify the delimiters, what line to start at etc, but you can also tell Excel (on the 3rd panel) that you want some columns to be treated as text. So, maybe if you renamed the file to .txt ... Hope this helps. Pete |
#3
Posted to microsoft.public.mac.office.excel,microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc
|
|||
|
|||
Disable auto-formatting dates.... GRRR!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting (Dates) Repost with additional data | Excel Discussion (Misc queries) | |||
Track Annual Inspection Due Dates Using Conditional Formatting | Excel Worksheet Functions | |||
How do I disable automatic date formatting in excel? | Excel Discussion (Misc queries) | |||
Auto Formatting an Excel Spreadsheet | Excel Discussion (Misc queries) | |||
Response to Frank: AM-PM Auto formatting | Excel Discussion (Misc queries) |