3 replies
by firefox
To me, it sounds like you have the cells formatted as Text instead of Number or Currency. See the Microsoft article ID #Q141765 at http://search.support.microsoft.com for details, or go directly to http://support.microsoft.com/support/kb/articles/Q141/7/65.asp?LN=EN-US&SD=gn&FR=0&qry=cell%20formatting&rnk=38&src=DHCS_MSPSS_gn_SRCH&SPR=XLW97
A couple of workarounds they mention is are:
Method 1: Retype the Numbers
After you change the format, retype the numbers.
Method 2: Select Edit Directly In Cell
On the Tools menu, click Options or Preferences, click the Edit tab, and verify
that the Edit Directly In Cell check box is selected. Double-click the cell you want to format, and press ENTER.
There are more methods listed, but they are too lengthy to post here.
I hope this helps. Good luck on Monday! :-)
by aburrus08
by aburrus08
This discussion is closed to new replies.
Trending Software posts
Sort by Trending