Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to store a date as yyyy-mm-dd. I however need this data to be
stored as text or 'general' and NOT convert to a date. I am importing this data to another system and need the actual data to go in as yyyy-mm-dd and when Excel converts this to a date it changes the underlying data and always crashes my import. Does anybody know how I can achieve this? I also tried to put a ' in front, however that then gets stored in the data field and does not work either. Thanks for the help. Brian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 Date Format Problem | Excel Discussion (Misc queries) | |||
Converting US Date Format | Excel Worksheet Functions | |||
Text entries behaving like numbers | Excel Discussion (Misc queries) | |||
Help: How do I convert a text date into a real date format | Excel Worksheet Functions | |||
Date Format Problems?? | Excel Discussion (Misc queries) |