Easier yet.

Erase nothing.

Format to General or Number then F2 and ENTER


Gord Dibben MS Excel MVP

On 6 Sep 2006 13:33:11 -0700, "ed" wrote:

It is really not necessary to erase and rebuild the formula. Just
erase the = sign, go to format/cell check *number* and pick the decimal
places and thousands , hit enter. Replace the = sign and hit enter and
the number should appear. If you are doing this elsewhere, change
the formatting on the entire range you intend to use before
constructing the formula.