| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Turning numbers into Dates
I would like to know how to turn a number such as "51319" into a date such as
"5/13/19". As of now, when I try to format the cell to a date format, it completely changes the date from "52309" to a random date such as "7/11/35". I have no idea why. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel is turning entered dates into formulas despite format. Why? | Excel Discussion (Misc queries) | |||
| how to stop numbers turning to hash ? | Excel Discussion (Misc queries) | |||
| Turning positive numbers to negative | Excel Discussion (Misc queries) | |||
| Numbers turning to Zero's | Excel Discussion (Misc queries) | |||
| How do I Turning Dates into Quarters | Excel Worksheet Functions | |||
Threaded Mode
