How To change the number after format to value ?

Question

i have the fill data by using series 1 to 9999 ,after that i copy it to next 9 column ,total 10 ,then i ctrl +1,custom cell format ,in the first row ,i let begin with 10000 and so on .the second row is begin with 20000.BUT I have found ,when i want to find up the number by using find and replace ,it cannot work .DO u have any idea ? for example ,the highlighted circle shown as below ,i want to change this to value 600009,when using the find and replace function ,it can be found out .

Answer 1

It would surely be just as easy to fill the actual number series you want rather than using custom cell formats, which will never alter the value. Or even use a formula like =A1+100000 and fill that across and down.

Answer 2

Excel doesn't offer this flexibility. You will need to search on whatever is shown in Formula bar i.e. on underlying value.

Answer 3

Okay ,this method is useful .thanks a lot .