| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why are my dates show up as (example) 39538 in formula?
I have been racking my brain to figure out why my formula is not working but
now I see that when reviewing the results through the functional argument tool I see that excel is reading the day (march 31 2010) as 39538. On the spreadsheet it clearly shows me the correct date format but when excel is reading the formula it is not. Can someone help? Thanks -- Neall |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates won't show? | Excel Discussion (Misc queries) | |||
| what is the formula to show the difference between two dates | Excel Discussion (Misc queries) | |||
| HOW DO I SET DATES TO SHOW ON MY SPREADSHEET? | Excel Worksheet Functions | |||
| HOW DO I SET DATES TO SHOW ON MY SPREADSHEET? | Excel Discussion (Misc queries) | |||
| Fractions show as dates | Excel Discussion (Misc queries) | |||
Threaded Mode
