Convert date (m/dd/yyyy) in text format into an excel recognised date
in [Programming]
|
From: Rob P on 11 Mar 2010 14:23 is there anyway to convert a TEXT field with a date into an excel recognised date? or the other way around - convert a date in excel into text output?
From: Bob Phillips on 11 Mar 2010 14:31 Try Text>Data To Columns, third page in the wizard. -- HTH Bob "Rob P" <gwatcheater(a)gmail.com> wrote in message news:f574bab6-e53d-4d72-9fec-8c197cf174f3(a)j27g2000yqn.googlegroups.com... > is there anyway to convert a TEXT field with a date into an excel > recognised date? > > or the other way around - convert a date in excel into text output?
|
Pages: 1 Prev: Referencing Chart Data? Next: Maintaining variables after program ends |