format in a cell referenece

[Legacy 93538]

Hi

Does anyone know hwo to referencing a cell and to keep its formatting?

I am using a formula below to create a string which takes the date in L48 and the number in K48 and adds to together so it results in "12/10/2010 at 50 uploads"

=Data!L48&" at "&Data!K48&" uploads"

However instead of keeping the date format it changes it, so the reuslt is "40688 at 50 uplaods"

Does anyone know how to keep the date format in this string?

thanks

Jessicaseymour

 

[pgc01]

Hi Jessica

Try:

=TEXT(Data!L48,"dd/mm/yyyy")&" at "&Data!K48&" uploads"

 

[Legacy 93538]

Thanks alot works great!!!

Thank so much for helping me

 

[pgc01]

I'm glad it helped. Cheers.