f unwanted formats.
Once XL has converted data to a date, it is a pain in the neck to get it to
convert it back.
Regards - Dave.
Date: Fri, 27 Nov 2009 16:10:12 +0530
Subject: $$Excel-Macros$$ Date format problem
From: 7jit...@gmail.com
To: excel-macros@googlegroups.com
Good Evening Excel Gurus,
If it has already been converted into date format and you want to reverse
it, use
=Text(date,"yy-mm-dd") or
=Text(date,"dd-mm-yy") the way you want
and then remove formulae by pasting only the values
Hemant Hegde
2009/11/27 Norman May
> Jitesh
>
> Try formatting the cells as TEXT
>
> Norma
Jitesh
Try formatting the cells as TEXT
Norman
On Fri, Nov 27, 2009 at 5:40 AM, Jitheesh Vazhapully <7jit...@gmail.com>wrote:
> Good Evening Excel Gurus,
>
> I have a data in this format 01-01-01, however as soon as I enter them in
> the excel sheet,excel picks it up as date and stores it in d
Type it as '01-01-01
On Fri, Nov 27, 2009 at 5:40 PM, Jitheesh Vazhapully <7jit...@gmail.com>wrote:
> Good Evening Excel Gurus,
>
> I have a data in this format 01-01-01, however as soon as I enter them in
> the excel sheet,excel picks it up as date and stores it in date format, Is
> there any wa
Good Evening Excel Gurus,
I have a data in this format 01-01-01, however as soon as I enter them in
the excel sheet,excel picks it up as date and stores it in date format, Is
there any way I can prevent this from happening.
Also how to convert this data back from date format 01/01/2001 to original
