ExcelBanter - auto change number entries

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - auto change number entries (https://www.excelbanter.com/excel-worksheet-functions/23269-auto-change-number-entries.html)

ToddG

auto change number entries

Is there a way that I can change all of the hard 8's entered into a worksheet
(not the 8's resulting from formulas) to all hard 9's without re-typing all
of the data?

Gord Dibben

F5SpecialConstants. Checkmark what you want..numbers? and OK your way out.

Formula cells will not be selected.

EditReplace

what: 8
with: 9

Gord Dibben Excel MVP

On Fri, 22 Apr 2005 13:06:03 -0700, "ToddG"
wrote:

Is there a way that I can change all of the hard 8's entered into a worksheet
(not the 8's resulting from formulas) to all hard 9's without re-typing all
of the data?

ToddG

Thank you.

"Gord Dibben" wrote:

F5SpecialConstants. Checkmark what you want..numbers? and OK your way out.

Formula cells will not be selected.

EditReplace

what: 8
with: 9

Gord Dibben Excel MVP

On Fri, 22 Apr 2005 13:06:03 -0700, "ToddG"
wrote:

Is there a way that I can change all of the hard 8's entered into a worksheet
(not the 8's resulting from formulas) to all hard 9's without re-typing all
of the data?

All times are GMT +1. The time now is 07:04 PM.