| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date to text format
I have a date in a cell in the following format 12/15/05. However I need to make this a true text field. I can do it manually by just going into that cell and preceding the date with a ' (single quote) so it would be '12/15/05 but I can't copy this down to all the other cells. Anyone know of an easy way to do this? -- nufsed ------------------------------------------------------------------------ nufsed's Profile: http://www.excelforum.com/member.php...o&userid=19264 View this thread: http://www.excelforum.com/showthread...hreadid=374433 |
|
#2
|
|||
|
|||
|
Format/Cells/Text, then fill down.
"nufsed" wrote in message ... I have a date in a cell in the following format 12/15/05. However I need to make this a true text field. I can do it manually by just going into that cell and preceding the date with a ' (single quote) so it would be '12/15/05 but I can't copy this down to all the other cells. Anyone know of an easy way to do this? -- nufsed ------------------------------------------------------------------------ nufsed's Profile: http://www.excelforum.com/member.php...o&userid=19264 View this thread: http://www.excelforum.com/showthread...hreadid=374433 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening a csv file with US date format on a Australian PC | Excel Discussion (Misc queries) | |||
| Format cells as date | Excel Discussion (Misc queries) | |||
| Date format within a text syntex? | Excel Worksheet Functions | |||
| problem with formatting cell to date format | Excel Worksheet Functions | |||
| Problem with Date format from VBA code | Excel Discussion (Misc queries) | |||
Linear Mode
