Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text always switching to date format
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text always switching to date format
FOrmat your cells as Text prior to entering data into them.
-- Gary''s Student gsnu200703 "Brian Haberman" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text always switching to date format
That did it. Wow, I know I had tried that a number of times and Excel was
changing it back on me. Anyway, thanks for the help. "Gary''s Student" wrote: FOrmat your cells as Text prior to entering data into them. -- Gary''s Student gsnu200703 "Brian Haberman" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text always switching to date format
Try this method.
In a cell enter =TEXT(cellref,"yyyy-mm-dd") Copy that and EditPaste Special(in place)ValuesOKEsc. Gord Dibben MS Excel MVP On Fri, 2 Feb 2007 08:35:03 -0800, Brian Haberman wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text always switching to date format
Just type in an ' (apostrophe) prior to typing in the date. This saves you
having to format the cell first -- John MOS Master Instructor Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Brian Haberman" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text always switching to date format
John,
As I had mentioned however, when I import this data into another system, I cannot have that leading apostrophe in the field. I need just the raw data formated as yyyy-mm-dd. Thanks however for the tip. Brian "john the confused" wrote: Just type in an ' (apostrophe) prior to typing in the date. This saves you having to format the cell first -- John MOS Master Instructor Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Brian Haberman" wrote: 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text always switching to date format
Brian
Did you look at my post in this thread? No leading apostrophe needed. Gord Dibben MS Excel MVP On Mon, 5 Feb 2007 10:38:00 -0800, Brian Haberman wrote: John, As I had mentioned however, when I import this data into another system, I cannot have that leading apostrophe in the field. I need just the raw data formated as yyyy-mm-dd. Thanks however for the tip. Brian "john the confused" wrote: Just type in an ' (apostrophe) prior to typing in the date. This saves you having to format the cell first -- John MOS Master Instructor Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Brian Haberman" wrote: 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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text always switching to date format
Gord,
Sorry it has taken so ling, but I did look at your post and that worked great as well. That is exactly what I need! Thanks for all the help. Regards, Brian "Gord Dibben" wrote: Brian Did you look at my post in this thread? No leading apostrophe needed. Gord Dibben MS Excel MVP On Mon, 5 Feb 2007 10:38:00 -0800, Brian Haberman wrote: John, As I had mentioned however, when I import this data into another system, I cannot have that leading apostrophe in the field. I need just the raw data formated as yyyy-mm-dd. Thanks however for the tip. Brian "john the confused" wrote: Just type in an ' (apostrophe) prior to typing in the date. This saves you having to format the cell first -- John MOS Master Instructor Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Brian Haberman" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |