Perhaps the cells were pre-formatted as Text.

Format all to General.

Copy an empty cell.

Select the range of numbers and EditPaste SpecialAddOKEsc.


Gord Dibben MS Excel MVP

On Tue, 18 Mar 2008 10:17:03 -0700, CCampbell
wrote:

I have a strange problem and wanted to know if anyone had experienced the
same thing and what the solution is. I created a new spreadsheet and entered
all of my data. Some entries were supposed to be formatted as currency but
they do not show that way. When I check the properties of the cell it shows
that it should be showing as currency. It also will not let me change the
alignment of these cells. And to make things stranger - this is only
happening on the first worksheet. Worksheets two and three work just fine. I
even tried copying the worksheet and it still had the same formatting problem
on the new worksheet. I'm assuming that there is something on the worksheet
that is causing this but I've exhausted my ideas and thought some here might
have a clue as to why this is doing this.