MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Number Formating Problems

Posted by Dave on February 15, 2002 8:35 AM

I have a worksheet that was emailed to me, when I try to sum to cells using "=sum(C17:C18)" I get 0, when I add them together like this "=C17+C18" I get 64 - the correct answer.

For some reason I cannot change the number format of the cells. If I right click and choose format cells nothing happens. When I try to use the "$" button to change it to currency it just bolds the text.

Any thoughts on what's happening, and how to fix?

Posted by Mark W. on February 15, 2002 8:38 AM

Your numbers are really text (e.g., "10"). Select
'em, choose the Data | Text to Columns... menu
command and press [ Finish ].

Posted by Dave on February 15, 2002 8:42 AM

thanks! (NT)