View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mark Lincoln Mark Lincoln is offline
external usenet poster
 
Posts: 227
Default Strange data type error

Try re-entering 1064.12 in the cell in question. Check that it aligns
to the right of the cell (assuming there is no other alignment set).

The cell may have been formatted as text and then changed to a number
format. In my experience, numbers entered in such cells remain as text
until re-entered.