Dates to number in edit line

[Guest]

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?

 

[Guest]

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

 

[Guest]

Perfect! thanks Duke

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

 

[Bob Phillips]

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")

 

[Guest]

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]

The more the merrier IMO

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.