View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default format troubles - possible cut/paste issue

Please try this.
Select all the cells in the worksheet using the CTRL + A keystrokes.
On the Edit menu, point to Clear, and click the Formats option.

If this post helps click Yes
--------------
Jacob Skaria


"sorrywm" wrote:

I copied some data into an Excel (2004) spreadsheet from the web, and now I
can't operate on the cells, despite the fact that their format is 'Number.'
I've tried re-copying the cells and paste-special-ing 'Value,' but to no
avail. Does anyone know how to make Excel recognize these perfectly good
numbers?