[newbie] copying a date value

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?

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?

Dear Jon

Use the TEXT function to conver a serial number date to any date format.

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

If this post helps click Yes
---------------
Jacob Skaria


"Jon" wrote:

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?