| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying part of a number string
I'm trying to manipulate a large number of dates for sorting. I only need
the year, but the data base has MMDDYYYY in it. I want to end up with YYYY only for a new sort. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copying part of a number string
If the dates are actual Excel dates, just formatted as MMDDYYYY,
use the YEAR function to get the year. E.g, =YEAR(A1) If the dates are not actual Excel dates, use the RIGHT function to get the last for characters. E.g., =RIGHT(A1,4) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Bill R" <Bill wrote in message ... I'm trying to manipulate a large number of dates for sorting. I only need the year, but the data base has MMDDYYYY in it. I want to end up with YYYY only for a new sort. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limit drop down list and linking to other info | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| converting number string to number with decimal | Excel Worksheet Functions | |||
| convert weekday string to number | Excel Discussion (Misc queries) | |||
| How to COnvert text string to number | Excel Discussion (Misc queries) | |||
Linear Mode
