Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
[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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
[newbie] copying a date value
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? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
[newbie] copying a date value
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying cell formula newbie. Thank You | Excel Discussion (Misc queries) | |||
copying cell formula newbie. | Excel Discussion (Misc queries) | |||
Real Newbie newbie question | New Users to Excel | |||
Newbie Date cells so most recent is on top | Excel Worksheet Functions | |||
Newbie question: Matching data/2 wkshts copying info over | Excel Worksheet Functions |