| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to replace a date, change May to June keeping numerical da
1-May format, find/replace does not work with this format
"nastech" wrote: Hi, not sure what format month is in, maybe can use find replace to replace all: May with June (binocular button, or edit, find..) "dolphinks72002" wrote: I have dates set up in a spreadsheet & would like to know how to change the month portion keeping the numerical portions so I can copy the sheet & just change the month without having to reformat the whole sheet. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare date against multiple dates | Excel Discussion (Misc queries) | |||
| Tex Dates to numerical Dates | Excel Worksheet Functions | |||
| Setting traffic lights based on todays date against target dates | Excel Discussion (Misc queries) | |||
| Help: Can I change the date formula from mm/dd/yyyy to "mmm-yy" et | Excel Discussion (Misc queries) | |||
| how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
Threaded Mode
