Solved How to change an incorrect date throughout a WB

July 30, 2018 at 13:09:17
Specs: Windows 64
Hi Guys,
Been a long while since I've been stumped, but I am

Been using my workbook that has up to 100 WSheets

Stupidly entered a Date, the 30-Jul-2018, when should have entered 30-Jun-2018
What I am trying to do is replace the incorrect date with the correct date on all WS where the incorrect date is


Have tried with Find & Replace , but no success
Any ideas and help would be greatly appreciated

Tony


See More: How to change an incorrect date throughout a WB

Reply ↓  Report •

#1
July 30, 2018 at 17:26:25
✔ Best Answer
Is the incorrect date the only instance of that date which appears on all the work sheets, or could you mistakenly change a correct date of 30-Jul-2018 to an incorrect date?

The simplest way I can think of is to GROUP all your worksheets and then use the
Find & Select option on the tool bar.

To Group the work sheets
Press and Hold the CTRL Key
and then press each sheet tab.
The sheet name at the top should display the sheet name with [Group] next to it.

Then using the Replace option on the ribbon
enter the date as shown in the formula box on your current sheet

So if your date in the cell is formatted as 30-Jul-2018
your formula box will probably show 7/30/2018, (unless your
not using US date format, then it will be something like 30/7/2018)
Use the 7/30/2018 in the find box.

See how that works

And why are you not posting in the Office Software forum..... :-)

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Reply ↓  Report •
Related Solutions


Ask Question