Date to text/number Conversion
 

Using today's date for example: =today() = 11/10/2009

Is it possible to convert the date to text shown as 11-10-2009?

Without typing it in as '11-10-2009

Thanks in Advance

Date to text/number Conversion
 

Format Cells... Custom mm-dd-yyyy
--
Gary''s Student - gsnu200908


"CM4@FL" wrote:

Using today's date for example: =today() = 11/10/2009

Is it possible to convert the date to text shown as 11-10-2009?

Without typing it in as '11-10-2009

Thanks in Advance

Date to text/number Conversion
 

=TEXT(TODAY(),"mm-dd-yyyy")
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"CM4@FL" wrote:

Using today's date for example: =today() = 11/10/2009

Is it possible to convert the date to text shown as 11-10-2009?

Without typing it in as '11-10-2009

Thanks in Advance

Date to text/number Conversion
 

=TEXT(A1,"mm-dd-yyyy")

If you just want to convert cell A1 =today() itself to that format...then
copy pastespecialvalies...and then format cellscustomType mm-dd-yyyy

If this post helps click Yes
---------------
Jacob Skaria


"CM4@FL" wrote:

Using today's date for example: =today() = 11/10/2009

Is it possible to convert the date to text shown as 11-10-2009?

Without typing it in as '11-10-2009

Thanks in Advance