| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Just because they are now formatted as dates doesn't mean that they
aren't text values. If you change the number format, does their appearance change? If not then you do still have text values in the cells. You can convert them to numerical values in a variety of ways. Since there are only 4 it's probably simplest to do F2, Enter in each of the cells. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
| Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
| Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Threaded Mode
