Hi Jitesh,
Format the cells as 'Text' before entering your data.
However, if your data is imported, or if you are pasting it from another place,
it may bring formatting with it.
If you are pasting it from another place, use Paste Special, then Values. This
will prevent the pasting of unwanted fo
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
