| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Dates
This is driving me batty. I hope someone can help. This is excel 2010.
When I type in 01011999 in a cell, then switch it to dates (no matter which format I choose, it comes out as different numbers. It'll show as 01/26/7435 or something crazy...I tried custom etc. What I want is for it to show up as 01/01/1999 - for the entire columb. Shouldn't be hard...yet I've tried almost everything. I even opened a new spreadsheet and started from scratch. Or the numbers will switch from 01011999 (which I want to read as 01/01/1999) to ##########. Last edited by JonathanK1 : January 11th 13 at 08:07 PM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking computer dates (time) to spreadsheet dates that have formu | Excel Worksheet Functions | |||
| match one column with dates to several colums with dates, copy pas | Excel Programming | |||
| compare 2 tables of dates to find the preceding dates | Excel Worksheet Functions | |||
| Toggle a range of Julian dates to Gregorian Dates and Back | Excel Programming | |||
| Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
Threaded Mode
