I want you to have some fun. I need something specific.

First i must explain what i do. I use a simple codification for product prices at retail store, because i dont want people know the real price for themselves. So i change the original numbers to another substracting the number 9 for each number. Normally I manually write down all the prices with this codification for every product.

So.. for example number 10 would be 89. (9-1 = 8) and (9-0 = 9) Other examples:

$128 = 871
$75 = 24
$236 = 763
$9 = 0
Finally i put 2 number nines (9) at the beginning of the codified price also, to confuse people who might think that number could be the price.

So the examples i used before are like this:

99871 (means $128)
9924 (means $75)
99763 (means $236)
990 (means $9)
Remember that i need 2 (two) nines before the real price. The real prices never start with 0 so, the nines are the begginning are only for confuse people.

Ok. So, now that you understand, here comes the 2nd part. I have an excel whith hundreds of my products added, with prices, description, etc. And i decided it is time to use a printer and start to print this information from excel. I have a software to do that, but first i need to have the codified prices in the excel also.

The fun part begins when i want to convert the real prices that are already written in my excel document into a new column AUTOMATICALLY. So that way i don΄t have to type again all the prices in codified form for the old and new items i add in the future.

Can someone help me with this? Is it even possible?

I tried with =A1-9999 but, it works well with 2 character number only. Because if the real price is 5, i will get 3 nines: 9994(code). And if the price is 234 i will get only 1 nine 9765(code). And it is a condition i need to have the TWO nines at first.

Thank you very much in advanced!