Sales Sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Tools>Options>Edit.

Uncheck the "Fixed decimal places" option button.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Value filter missing in pivot table 3
Sorting based on one column 1
How do I automatically generate a worksheet. 1
copying data from master ti individual sheets 3
How to enter a name in one cell, and have it return their sales $. 2
i have a list i need to copy onto another sheet one by one 2
Sum based on date in another cell 5
anyone have a basic sales tracker 1

Back
Top