The number is still 12345 NOT 1234501: the 01 is only formatting. Look at the
number in the formula bar.

"sammies3" wrote:

Many Thanks

I have just found another way too
go to format cells then custom, type ##### for the amount of digit in the
cell followed by "0"1
so it reads #####"0"1
12345 turns to 1234501

"Jim Thomlinson" wrote:

Multiply the numbers by 100 and then add 1.

--
HTH...

Jim Thomlinson


"sammies3" wrote:

i have 500 numbers in rows, i need to add 01 to the end of all the numbers is
there anyway easy of doing this