Convert YYYY, MM, and DD as a single number string
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
"Sheeloo" wrote in message
...
No. Morrison who posted the problem....
"Peo Sjoblom" wrote:
Are you addressing me?
--
Regards,
Peo Sjoblom
"Sheeloo" wrote in message
...
This shoud work. Did you test this out?
"Peo Sjoblom" wrote:
Looks like you have real dates and times in your cells
=TEXT(A1,"YYYY")&TEXT(B1,"MM")&TEXT(C1,"DD")&" - "&D1
--
Regards,
Peo Sjoblom
"rmorrison" wrote in message
...
The value now displays
39710.604976388939710.604976388939710.6049763889-101
It should display 20080919-0101. It doesn't seem to be working.
"Sheeloo" wrote:
Requirement not clear. Do you want YYYYMMDD-#### in a cell and you
have
all
the components in different cells?
Enter this in F1
=A1&B1$C1&"-"&D1 assuming you have the above in Col A-D
"rmorrison" wrote:
I have YYYY, MM, and DD entered in separate cells in Excel 2007.
I
want to
create a new Job Number with YYYYMMDD-####, where #### is a new
job
which is
attached to the date string. How do I do this?
|