Thread: Sales Sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Sales Sheet

ToolsOptionsEdit.

Uncheck the "Fixed decimal places" option button.


Gord Dibben MS Excel MVP

On Sun, 2 Jul 2006 12:36:01 -0700, brettingsworth
wrote:

Hi Guys,

Really dumb question. Creating a basic spreadsheet to track sales. The
majority of the cells are currency based except for the first one which would
show a basic number without decimals (ie: 23). When I type in 23, it
generates 0.23. How can I get rid of this so I can just have a basic # typed
in there?

Please help.