| 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? |
| 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 | |||
Threaded Mode
