|
|
#7
01-30-2018, 08:42 PM
|
|||
|
|||
Yeah, I can't explain it.
I tried what you said, p45cal--I switched all the dates to general, and indeed some remained just the text of the date while others became numbers (the numbers I can't explain; for example, March 24, 2017 became 42818 <-- Huh!?). But trying to switch them back to date doesn't seem to work. I try all kinds of formats, hoping Excel recognizes at least one, but it doesn't. Anyway, I'm attaching the file in case anyone wants to take a crack at it. Thanks very much for trying to help. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I make a simple graph with a list of dates at the bottom? | MRnightmuffin | Excel | 1 | 01-18-2018 06:48 PM |
 Format cells dependent on given dates
|
fizzwolf | Excel | 1 | 05-04-2016 09:21 AM |
| Priority of line graph vs bar graph in terms of front to back positioning on a chart | DavePPointuser | PowerPoint | 1 | 04-30-2014 10:57 AM |
| Date Format: how to output dates that are not US? | tinfanide | Word VBA | 0 | 10-28-2013 03:30 AM |
| How to change number format of dates | ketanco | Project | 1 | 09-11-2012 02:34 PM |
Windows 10 
Office 2003
Threaded Mode