|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 13th, 2005, 07:15 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
Date Conversion - sorry
OK, guys, I've read a plethora of posts about DATE, but can't find one that
suits my situation. It's probably out there somewhere,... please help. I have a cell D2 it's formated as a date 03/01/04 field I have another numeric field in K5 (just numbers e.g. 3428) I want cell J2 to be 20040301-3428. So, do I need to convert D2 to a data yyyymmdd? then convert to text? then add the hyphen? then add the number? It's probably simple, but I've spent too much time on this. I keep getting the serial date or whatever that 38,889 number is. 
|
|
#2
December 13th, 2005, 07:21 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Date Conversion - sorry
=TEXT(D2,"yyyymmdd")&"-"&TEXT(K5,"#")
-- Kind regards, Niek Otten "DTTODGG" wrote in message ... OK, guys, I've read a plethora of posts about DATE, but can't find one that suits my situation. It's probably out there somewhere,... please help. I have a cell D2 it's formated as a date 03/01/04 field I have another numeric field in K5 (just numbers e.g. 3428) I want cell J2 to be 20040301-3428. So, do I need to convert D2 to a data yyyymmdd? then convert to text? then add the hyphen? then add the number? It's probably simple, but I've spent too much time on this. I keep getting the serial date or whatever that 38,889 number is.
|
|
#3
December 13th, 2005, 07:26 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Date Conversion - sorry
=TEXT(D2,"yyyymmdd")&"-"&K5. If you need to force the suffix to a certain
number of digits, you could use &text(k5,"0000") instead of just &K5. "DTTODGG" wrote: OK, guys, I've read a plethora of posts about DATE, but can't find one that suits my situation. It's probably out there somewhere,... please help. I have a cell D2 it's formated as a date 03/01/04 field I have another numeric field in K5 (just numbers e.g. 3428) I want cell J2 to be 20040301-3428. So, do I need to convert D2 to a data yyyymmdd? then convert to text? then add the hyphen? then add the number? It's probably simple, but I've spent too much time on this. I keep getting the serial date or whatever that 38,889 number is.
|
|
#4
December 13th, 2005, 07:27 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Date Conversion - sorry
I have no idea what you're doing....but, I think this will do it:
=TEXT(D2,"yyyymmdd")&"-"&K5 Does that help? *********** Regards, Ron "DTTODGG" wrote: OK, guys, I've read a plethora of posts about DATE, but can't find one that suits my situation. It's probably out there somewhere,... please help. I have a cell D2 it's formated as a date 03/01/04 field I have another numeric field in K5 (just numbers e.g. 3428) I want cell J2 to be 20040301-3428. So, do I need to convert D2 to a data yyyymmdd? then convert to text? then add the hyphen? then add the number? It's probably simple, but I've spent too much time on this. I keep getting the serial date or whatever that 38,889 number is.
|
|
#5
December 13th, 2005, 07:27 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Date Conversion - sorry
Or, if you always want to copy K2, no matter if it has decimals,
=TEXT(D2,"yyyymmdd")&"-"&K5 -- Kind regards, Niek Otten "Niek Otten" wrote in message ... =TEXT(D2,"yyyymmdd")&"-"&TEXT(K5,"#") -- Kind regards, Niek Otten "DTTODGG" wrote in message ... OK, guys, I've read a plethora of posts about DATE, but can't find one that suits my situation. It's probably out there somewhere,... please help. I have a cell D2 it's formated as a date 03/01/04 field I have another numeric field in K5 (just numbers e.g. 3428) I want cell J2 to be 20040301-3428. So, do I need to convert D2 to a data yyyymmdd? then convert to text? then add the hyphen? then add the number? It's probably simple, but I've spent too much time on this. I keep getting the serial date or whatever that 38,889 number is.
|
|
#6
December 13th, 2005, 07:36 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Date Conversion - sorry
Thank you guys SOoooo much - you wouldn't want to see the combinations I've
tried. :-) "DTTODGG" wrote: OK, guys, I've read a plethora of posts about DATE, but can't find one that suits my situation. It's probably out there somewhere,... please help. I have a cell D2 it's formated as a date 03/01/04 field I have another numeric field in K5 (just numbers e.g. 3428) I want cell J2 to be 20040301-3428. So, do I need to convert D2 to a data yyyymmdd? then convert to text? then add the hyphen? then add the number? It's probably simple, but I've spent too much time on this. I keep getting the serial date or whatever that 38,889 number is.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Reports with Date Range - Errors | jwr | Setting Up & Running Reports | 12 | August 8th, 2005 12:57 PM |
| Revised Date Question | Spectra | Running & Setting Up Queries | 0 | March 18th, 2005 12:19 PM |
| unwanted number to date conversion while pasting data from web | Jacek | Worksheet Functions | 1 | February 24th, 2005 02:59 PM |
| Date Conversion Hijri to Gregorian | SalimShahzad | General Discussion | 5 | January 12th, 2005 08:27 AM |
| QDE (Quick Date Entry) | Norman Harker | Worksheet Functions | 37 | September 5th, 2004 01:24 AM |
Linear Mode
