Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert numbers to date: "586" to read "May 1986"
I have a huge spreadsheet where all the dates in the date column are listed
as myy. For example "586" should be May 1986, and "801" should be August 2001. Is there any way to convert the whole column so i dont' have to manually change them? If it helps, the file was an Access file my client burned toa CD. I opened it on another computer and this was how the column appeared, so I'mnot sure if its a formatting error on his end, or if that is how he actually entered the data. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
any formula to convert numbers in word form, e.g. "2" as "Two"? | Excel Worksheet Functions | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |