Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Dates to number in edit line
In cell A:1 I have 15/05/1974 which is formatted as 19740515
I want to see 19740515 in the edit line as I need to create a csv with 19740515 and not 27164 Any ideas? |
#2
|
|||
|
|||
WORK ON A COPY OF YOUR FILE
You'll need to use a helper column in which you put a text formula along the lines of this (assuming your first date is in A1) =year(A1)&text(month(a1),"00")&text(day(a1),"00") When all is as you want, then convert the formulas to values and delete the column with the actual dates "Skip4t4" wrote: In cell A:1 I have 15/05/1974 which is formatted as 19740515 I want to see 19740515 in the edit line as I need to create a csv with 19740515 and not 27164 Any ideas? |
#3
|
|||
|
|||
Perfect! thanks Duke
"Duke Carey" wrote: WORK ON A COPY OF YOUR FILE You'll need to use a helper column in which you put a text formula along the lines of this (assuming your first date is in A1) =year(A1)&text(month(a1),"00")&text(day(a1),"00") When all is as you want, then convert the formulas to values and delete the column with the actual dates "Skip4t4" wrote: In cell A:1 I have 15/05/1974 which is formatted as 19740515 I want to see 19740515 in the edit line as I need to create a csv with 19740515 and not 27164 Any ideas? |
#4
|
|||
|
|||
"Duke Carey" wrote in message ... You'll need to use a helper column in which you put a text formula along the lines of this (assuming your first date is in A1) =year(A1)&text(month(a1),"00")&text(day(a1),"00") =TEXT(A1,"yyyymmdd") |
#5
|
|||
|
|||
Bob -
Yeah, sure, that is clearly easier, better, etc., but the OP didn't ask for the 'best' idea, just for 'any' ideas. Still not enough sleep last night. "Bob Phillips" wrote: "Duke Carey" wrote in message ... You'll need to use a helper column in which you put a text formula along the lines of this (assuming your first date is in A1) =year(A1)&text(month(a1),"00")&text(day(a1),"00") =TEXT(A1,"yyyymmdd") |
#6
|
|||
|
|||
The more the merrier IMO
"Duke Carey" wrote in message ... Bob - Yeah, sure, that is clearly easier, better, etc., but the OP didn't ask for the 'best' idea, just for 'any' ideas. Still not enough sleep last night. "Bob Phillips" wrote: "Duke Carey" wrote in message ... You'll need to use a helper column in which you put a text formula along the lines of this (assuming your first date is in A1) =year(A1)&text(month(a1),"00")&text(day(a1),"00") =TEXT(A1,"yyyymmdd") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Determining the number of specific days between two dates in Excel | Excel Worksheet Functions | |||
Count the number of dates in a range that are earlier than today. | Excel Worksheet Functions | |||
Where is DateDiff function in Excel 2002 ? | Excel Worksheet Functions | |||
Find number of days between to dates | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |