Date to text format question

[JHB]

I am attempting to convert a date to text, and am having trouble with
the formatting. Specifically, I wish to convert a date in the form mm/
dd/yyyy to text in exactly the same format.

I am using excel 2000.

Using the command =Text(Text,text-format), I am having trouble with
the format piece.

"Help" tell me that the format code is based on he "format cells
numeric" definitions. My problem is that the code appears to be a
number, and nowhere can I find what number produces what defined text
format!

Can someone either give me the code I need, or point me in the right
direction to get an answer.

Thanks in advance

 

[Mike H]

No need to post again look in you other post and tell me what's wrong with my
answer and we'll fix it

 

[Satyendra_Haldaur]

what if you will use format>cells> text format and not the formula
and if you want to use formula you can use it like this.
=text(a1,"MM/DD/YYYY")
where a1 is the cell contains date.

 

[Mike H]

Format|Cells|Text will display the date as a number

 

[Teethless mama]

Try this:

=TEXT(A1," m/d/yyyy")