Sales Sheet
 

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.

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.

Sales Sheet
 

ToolsOptions...ViewFixed decimals...un-check it

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"brettingsworth" wrote in message
...
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.

Sales Sheet
 

Thanks Gord. Told you it was something dumb. Thanks again.

"Gord Dibben" wrote:

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.