Yes I tried that but it still doesnt change. When I go to the formatting menu
it shows that the cell has a general format and I change it to currency and
hit enter but it still sits on the left hand of the sell and it is not
currency.

"mrice" wrote:


Is the worksheet protected?

Have you tried deleting the cell and then shifting the other affected
cells back to their original positions?


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=563573