How to replace a date, change May to June keeping numerical dates
 

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.

How to replace a date, change May to June keeping numerical dates
 

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.

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.