Hi
Try this

="Payslip period from"&" "&TEXT('Current payroll'!B3,"dd/mm/yyy")&" "&"to"&"
"&TEXT('Current payroll'!D3,"dd/mm/yyyy")


--
Hope this help

Pls click the Yes button below if this post provide the answer you asked


cheers, francis

"Jon" wrote in message
...
I'm trying to get the date value in dddd dd/mm/yyyy format, however, when
using this formula, the date returned seems to be the "excel serial
number":

="Payslip period from"&" "&'Current payroll'!$B$3 & " to " & 'Current
payroll'!D3

Returns: Payslip period from 39895 to 39908, whilst I would like to copy
23/03/2009 and 05/04/2009 respectively.

Any idea how to convert the format?