Quite an onerous method if you have 1234000 cells<g

Go with the paste specialadd


Gord Dibben MS Excel MVP


On Thu, 1 Oct 2009 10:44:23 -0700, Bzltyr
wrote:

Thanks for the advice. There is a shortcut that all one has to do is
highlight the cell and hit the shortcut key and the same value that is in the
cell will just be renetered and will change from text to number.