| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text to number conversion with trailing - | Excel Discussion (Misc queries) | |||
| Issue with Number Conversion to text | Excel Worksheet Functions | |||
| Date to number conversion | Excel Discussion (Misc queries) | |||
| stop number to date conversion | Setting up and Configuration of Excel | |||
| Text to Number conversion | New Users to Excel | |||
![CM4@FL[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
