| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Date Format to Specific Text Format When Copying
I have a certain cell that is used to input a date. I want to be able to
push a button and copy this date to antoher cell, however I need the formatting to change from the original date format to a text format that goes yyyy-mm-dd. I've tried using a custom format and then changing that to text but the date just changes to a number. Any suggestions? Thanks Adam Bush |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Change Changing Date Format Data to Text | Excel Discussion (Misc queries) | |||
| how can I format a cell to change on a specific date | New Users to Excel | |||
| how do i change text format date to date (i.e., mm/yy to mm/dd/yyy | Excel Discussion (Misc queries) | |||
| how to change number to text with specific format in function | Excel Worksheet Functions | |||
| CHANGE TEXT TO DATE FORMAT | Excel Discussion (Misc queries) | |||
Threaded Mode
