| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date to TEXT. NOT to sequential serial number
I need to convert the date in a date formatted column to text, and not the
sequential serial numbers. If I try to convert a date to text, I get the sequential serial number, but I need to have it as a string so I can manipuate the individual characters. So if I have 09/10/05 in A1 which was entered as a date formatted cell, I would like to fix it as the characters: 09/10/05, rather than the sequential serial number (38605). Any thoughts would be appreciated. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pasting data from a website changes text to date | Excel Discussion (Misc queries) | |||
| Combining Text and Date for VLOOKUP | Excel Worksheet Functions | |||
| How do I convert Date serial number to date | Excel Worksheet Functions | |||
| Use Julian Date To Create Serial Number | Excel Discussion (Misc queries) | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Threaded Mode
