how do I keep date format when using =J5&" EDIT4 01" ?

[Fucius]

Hi guys,

I'm using the following code: =J5&" EDIT4 01"

to get this:

8/30/11 EDIT4 01

but instead, I'm getting this:

40785 EDIT4 01

how do I get it to keep date format?

Thanks guys!

 

[pagrender]

Try this:

=text(J5,"MM/DD/YY")&" EDIT4 01"

 

[Fucius]

Awesome! it worked, thanks so much!

 

[pagrender]

Thanks for the feedback!