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

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

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

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

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

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

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

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