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
|