Convert YYYY, MM, and DD as a single number string
You are right....
"Peo Sjoblom" wrote:
If you look at the numbers he/she got the first one 39710 is the serial
number for the date 09/19/08 using US format which makes me believe the
value in his first cell is not 2008 but the real date formatted as YYYY and
this part
39710.604976388939710
is equal to
9/19/2008 2:31:10 PM
so I suspect he/she might have a formula like NOW() in a cell and has
formatted it as YYYY and maybe the next cell as MM etc
--
Regards,
Peo Sjoblom
|