Sales Sheet

[brettingsworth]

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.

[Gord Dibben]

Tools>Options>Edit.

Uncheck the "Fixed decimal places" option button.


Gord Dibben MS Excel MVP

On Sun, 2 Jul 2006 12:36:01 -0700, brettingsworth
<brettingsworth@discussions.microsoft.com> 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.

[Nick Hodge]

Tools>Options...>View>Fixed decimals...un-check it

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"brettingsworth" <brettingsworth@discussions.microsoft.com> wrote in message
news:8D021757-B4A1-45D4-AF5A-AEFACB3D5C08@microsoft.com...
> 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.

[brettingsworth]

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

"Gord Dibben" wrote:

> Tools>Options>Edit.
>
> Uncheck the "Fixed decimal places" option button.
>
>
> Gord Dibben MS Excel MVP
>
> On Sun, 2 Jul 2006 12:36:01 -0700, brettingsworth
> <brettingsworth@discussions.microsoft.com> 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.
>
>