| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing 4 digits into 2 digit year
I have a cell with 2003 as a number and I want another cell to copy it
as 03. Inotherwords I enter 2003 in one cell and and I want it copied to another cell as 03 (to represent a 2 digit year). Seems simple but I'm going brain dead today so I'm having trouble. I'd like to do this without macros or vba. Excel advice please |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert day of year to numeric value format year+day in 4 digits | Excel Worksheet Functions | |||
| Addendum to 2 digit year to 4 digit year | Excel Discussion (Misc queries) | |||
| Format 2 digit year to 4 digit | Excel Discussion (Misc queries) | |||
| Getting the first 3 digits out of 6 digit cells? | Excel Worksheet Functions | |||
| Why is Excel changing the last 2 digits of a 17 digit num to 00. | Excel Discussion (Misc queries) | |||
Threaded Mode
