| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Dates in fomula showing as whole number
I have a fomula in a cell that takes the name of a person (from cell 2B),
their License number (from another cell 2C)and the Date that License Expires (From cell 2D). The expire date in "2D" is either the word "none" or a date that that persons license needs to be renewed. Those instructors with "None" come out in the calculated field fine, however the ones with dates come back as whole numbers, Example 8/6/10 shows 40396. any help will be appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop dates from showing as numbers - when formated as dates | Excel Discussion (Misc queries) | |||
| What is fomula for entering dates that are 7 days apart? | Excel Worksheet Functions | |||
| Fomula for number of days on each month from a date range | Excel Discussion (Misc queries) | |||
| Dates showing are not what I type | New Users to Excel | |||
| include maximum number in fomula | Excel Worksheet Functions | |||
Threaded Mode
