conversion of a date in excel 2

[collierd]

Hello

Within Excel I have a date displayed as Jul-06 (this is 01/07/06)
I have another cell with a reference in it (ASP)

I am looking to concatinate these 2 cell with a * delimiter to form

01/07/06*ASP

I can't seem able to do this as the system converts this to an internal date

Does anybody have any ideas how to go about achieving this?

Thanks

Damian.

 

[SkipVought]

Hi,

Use the TEXT function
[tt]
=TEXT(A1,"mm/dd/yy")&" * "&A2
[/tt]
assuming that A1 has the date and A2 has ASP

Skip,

_[red][/red]

 

[bluedragon2]

=TEXT(A1,"mmm-dd")&" * "&B1

With the date in A1 and ASP in B1

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[collierd]

Thank you