date to text (not serial number)
 

How do I convert 02/11/09 to 021109?

Thanks

date to text (not serial number)
 

Two possibles...

Just add a custom format. Right click the date and select Format Cells -
Number tab - Custom and change the format to ddmmyy

Or use the formula
=text(a1, "ddmmyy")
where your date is in A1.
--
HTH...

Jim Thomlinson


"jsv" wrote:

How do I convert 02/11/09 to 021109?

Thanks

date to text (not serial number)
 

Perhaps

=TEXT(A1,"mmddyy")

Mike

"jsv" wrote:

How do I convert 02/11/09 to 021109?

Thanks

date to text (not serial number)
 

=TEXT("02/11/09","mmddyyyy")

If the date is in A1 then use this in any other cell
=Text(a1,"mmddyyyy")

"jsv" wrote:

How do I convert 02/11/09 to 021109?

Thanks

date to text (not serial number)
 

Hi,

Take a look here at Chip Pearson's site
http://www.cpearson.com/excel/jdates.htm

I think that should do what you want.


HTH
Martin




"jsv" wrote in message
...
How do I convert 02/11/09 to 021109?

Thanks

date to text (not serial number)
 

No, Martin.
That page is about Julian dates, which wasn't what the OP asked for.
--
David Biddulph

MartinW wrote:
Hi,

Take a look here at Chip Pearson's site
http://www.cpearson.com/excel/jdates.htm

I think that should do what you want.

HTH
Martin

"jsv" wrote in message
...
How do I convert 02/11/09 to 021109?

Thanks