Re: auto change number entries

From: "ToddG" <ToddG@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Mon, 25 Apr 2005 05:46:02 -0700

Thank you.

"Gord Dibben" wrote:

> F5>Special>Constants. Checkmark what you want..numbers? and OK your way out.
>
> Formula cells will not be selected.
>
> Edit>Replace
>
> what: 8
> with: 9
>
>
> Gord Dibben Excel MVP
>
> On Fri, 22 Apr 2005 13:06:03 -0700, "ToddG" <ToddG@xxxxxxxxxxxxxxxxxxxxxxxxx>
> wrote:
>
> >Is there a way that I can change all of the hard 8's entered into a work***
> >(not the 8's resulting from formulas) to all hard 9's without re-typing all
> >of the data?
>
>
.

References:
- auto change number entries
  - From: ToddG
- Re: auto change number entries
  - From: Gord Dibben

Prev by Date: Letter and numeral separation
Next by Date: Re: SUMIF with 2 criterias
Previous by thread: Re: auto change number entries
Next by thread: Is there a way to import a pdf file in to Excel
Index(es):
- Date
- Thread