Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Dates to text
I am trying to convert a date - 2/3/06 - into text format to run an INDIRECT formula. I want the date to convert to 02-03-06 as text. Would there be a way to do this without having to retype the date? drummer -- lmullenjr ------------------------------------------------------------------------ lmullenjr's Profile: http://www.excelforum.com/member.php...o&userid=33132 View this thread: http://www.excelforum.com/showthread...hreadid=573046 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates formatted as text | Excel Discussion (Misc queries) | |||
imported text data converting to dates | Excel Discussion (Misc queries) | |||
Convert text numbers to numbers | Excel Worksheet Functions | |||
convert numbers to text | Excel Discussion (Misc queries) | |||
How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) |