Extract Date (04/05/06) into Text (040506)

[Who I Am]

I need a formula or a VBA code to extract a date into a string. Could
you shed a light?

Thanks in advance.

[Ron Coderre]

Perhaps something like this:

For a date in A1

B1: =TEXT(A1,"mmddyy")

You might also be able to just use a custom number format

Select A1
<format><cells><number tab>
Category: Custom
Type: mmddyy
Click the [OK] button

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Who I Am" wrote:

> I need a formula or a VBA code to extract a date into a string. Could
> you shed a light?
>
> Thanks in advance.
>
>

[AA2e72E]

Or, try:

replace(yourDateVaraibleOrvalue,"/","")

[ward376]

=LEFT((TEXT(A1,"MM/DD/YY")),2)&MID((TEXT(A1,"MM/DD/YY")),4,2)&RIGHT((TEXT(A1,"MM/DD/YY")),2)

[ward376]

=LEFT((TEXT(A1,"MM/DD/YY")),2)&MID((TEXT(A1,"MM/DD/YY")),4,2)&RIGHT((TEXT(A1,"MM/DD/YY")),2)

[ward376]

oops, double post

This formula will give you mmddyy as text as long as excel recognizes
it as a date regardless of format. Even if it's formatted as a number,
general etc.

[ward376]

=LEFT((TEXT(A1,"MM/DD/YY")),2)&MID((TEXT(A1,"MM/DD/YY")),4,2)&RIGHT((TEXT(A1,"MM/DD/YY")),2)