| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to replace a / with - in a date
I'm using Date() to pull the current date. How do I replace the / with - ?
The reason I want to do this I want to attach this to a filename. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to replace a / with - in a date
=TEXT(cell_with_date,"yyyy-mm-dd")
or whatever date format you are using -- Regards, Peo Sjoblom "pokdbz" wrote in message ... I'm using Date() to pull the current date. How do I replace the / with - ? The reason I want to do this I want to attach this to a filename. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find and replace for date format | Excel Discussion (Misc queries) | |||
| Replace date 00.01.1900 | Excel Discussion (Misc queries) | |||
| The Find or Replace will not work on a date. | Excel Discussion (Misc queries) | |||
| Replace part of link address in a cell with a value(date) from ano | Excel Discussion (Misc queries) | |||
| How do I replace dates earlier than certain date? | Excel Discussion (Misc queries) | |||
Linear Mode
