software

I have dates set up in a spreadsheet amp; would like to know how to change the
month portion keeping the numerical portions so I can copy the sheet amp; just
change the month without having to reformat the whole sheet.

Hi, not sure what format month is in, maybe can use find replace to replace
all:
May with June (binocular button, or edit, find..)

quot;dolphinks72002quot; wrote:

gt; I have dates set up in a spreadsheet amp; would like to know how to change the
gt; month portion keeping the numerical portions so I can copy the sheet amp; just
gt; change the month without having to reformat the whole sheet.

1-May format, find/replace does not work with this format

quot;nastechquot; wrote:

gt; Hi, not sure what format month is in, maybe can use find replace to replace
gt; all:
gt; May with June (binocular button, or edit, find..)
gt;
gt; quot;dolphinks72002quot; wrote:
gt;
gt; gt; I have dates set up in a spreadsheet amp; would like to know how to change the
gt; gt; month portion keeping the numerical portions so I can copy the sheet amp; just
gt; gt; change the month without having to reformat the whole sheet.