| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
return the 2 diget year value
thanx everyone
the =text is fine as i have to "paste values" later anyway to clear all formulae then delimit for further use "Dave Peterson" wrote: Another one: =text(a1,"yy") (to return text) or =--text(a1,"yy") (to return a number) EngelseBoer wrote: how can i return the yy value of a date please ie 1996 returns 96 -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return across Row Numeric Values Matching EXACT Month & Year for Criteria | Excel Worksheet Functions | |||
| Excel NPV initial cost in value1 and first year return in value2? | Excel Worksheet Functions | |||
| Need cell formulas to return the day of every Monday in a month based on year entered | Excel Discussion (Misc queries) | |||
| 2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
| Year-to-date return | Excel Worksheet Functions | |||
Threaded Mode
