Hi, thanks for that.. don't know that much, But can I enter something like
that in custom formatting for date? (trying for all in same column, already
have yymmdd in custom formatting) Thanks

"R.VENKATARAMAN" wrote:

a1 11/2/05

b1 =TEXT(A1,"yymmdd")
you will get b1 051102
====================

"nastech" wrote in message
...
Is there a manner of formatting to see date as Text?, if entered in same
cell. Think that is what I need. Using custom formatting: yymmdd and
making column narrow, so just see dd (with right justify).

Problem is that going from text to date format, just see ##
is there way to make yymmdd in custom to conform to text??? Thanks