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?

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?

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?

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

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

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