dates
 

How can I change the date format 01/01/08 to 010108

dates
 

Select the cell and give it a custom format of mmddyy. Select Format Cells
on the Number tab, select Custom in the Type box, enter mmddyy OK.

Hope this helps,

Hutch

"rebecca" wrote:

How can I change the date format 01/01/08 to 010108

dates
 

"Tom Hutchins" wrote:

Select the cell and give it a custom format of mmddyy. Select Format Cells
on the Number tab, select Custom in the Type box, enter mmddyy OK.

Hope this helps,

Hutch

"rebecca" wrote:

How can I change the date format 01/01/08 to 010108

I ALSO NEED TO CHANGE THE FORMAT INTO A TEXT CELL. WHEN I TRY TO DO THIS IT
GIVES ME A NUMBER THAT EXCEL RECOGINZES AS A SUM NUMBER (I THINK)

dates
 

Hi Rebecca
Try
=SUBSTITUTE(TEXT(A1,"dd/mm/yy"),"/","")

--
Regards
Roger Govier

"rebecca" wrote in message
...


"Tom Hutchins" wrote:

Select the cell and give it a custom format of mmddyy. Select Format
Cells
on the Number tab, select Custom in the Type box, enter mmddyy
OK.

Hope this helps,

Hutch

"rebecca" wrote:

How can I change the date format 01/01/08 to 010108

I ALSO NEED TO CHANGE THE FORMAT INTO A TEXT CELL. WHEN I TRY TO DO THIS
IT
GIVES ME A NUMBER THAT EXCEL RECOGINZES AS A SUM NUMBER (I THINK)

dates
 

Try
=SUBSTITUTE(TEXT(A1,"dd/mm/yy"),"/","")

Why not just this instead...

=TEXT(A1,"ddmmyy")

--
Rick (MVP - Excel)

dates
 

Because I like to make things more complicated than they need be, Rick<bg

--
Regards
Roger Govier

"Rick Rothstein" wrote in message
...
Try
=SUBSTITUTE(TEXT(A1,"dd/mm/yy"),"/","")

Why not just this instead...

=TEXT(A1,"ddmmyy")

--
Rick (MVP - Excel)

dates
 

LOL

--
Rick (MVP - Excel)


"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Because I like to make things more complicated than they need be, Rick<bg

--
Regards
Roger Govier

"Rick Rothstein" wrote in message
...
Try
=SUBSTITUTE(TEXT(A1,"dd/mm/yy"),"/","")

Why not just this instead...

=TEXT(A1,"ddmmyy")

--
Rick (MVP - Excel)