Dates to number in edit line

S

Skip4t4

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?
 
D

Duke Carey

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
 
S

Skip4t4

Perfect! thanks Duke

Duke Carey said:
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
Click to expand...
 
B

Bob Phillips

Duke Carey said:
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")
Click to expand...

=TEXT(A1,"yyyymmdd")
 
D

Duke Carey

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.
 
B

Bob Phillips

The more the merrier IMO

Duke Carey said:
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.
Click to expand...
 
Top