| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers To Dates
Is there an easy way to change numbers within a cell into dates with a
format, or formula within a macro? For example: The Number in the cells are as follows: 406 which stands for April 2006 1205 Which stands for December 2005 I want to change those numbers that are there into a nicer looking date format, like Apr-06 or something. THANKS!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prevent excel changing numbers data to dates. | Excel Discussion (Misc queries) | |||
| reversing numbers to create dates | Excel Worksheet Functions | |||
| Calculate numbers between 2 dates | Excel Discussion (Misc queries) | |||
| Converting Text months to sortable Numbers or Dates | Excel Discussion (Misc queries) | |||
| Dates to numbers | Excel Worksheet Functions | |||
Threaded Mode
