How do I keep fixed and Non-fixed decimals on a sheet together?

[kpike]

I am creating a spreadsheet that includes currency values and would like to
maintain two decimal places for ease in data entry. The same sheet includes
a series of ticket numbers for which I want no decimal at all. I cannot find
a way to keep both of these functions on the same sheet. I have had to
reapply the tools option every time I get to these cells. Is there an easier
way to make it stick?

[Franz Verga]

Nel post news:BF42EE91-CFCB-460A-A9A5-7040B631E622@microsoft.com
*kpike* ha scritto:

> I am creating a spreadsheet that includes currency values and would
> like to maintain two decimal places for ease in data entry. The same
> sheet includes a series of ticket numbers for which I want no decimal
> at all. I cannot find a way to keep both of these functions on the
> same sheet. I have had to reapply the tools option every time I get
> to these cells. Is there an easier way to make it stick?


Maybe you can use Data Validation...

--
(I'm not sure of names of menues, option and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Ciao

Franz Verga from Italy

[Gord Dibben]

You can have more than one decimal place formatting on the same sheet.

Your ticket number cells can be formatted for no decimals.

Format>Cells>Number>Number>Decimal Places. Set to 0

Leave your other cells as 2-decimal currency.

BTW........what does the Tools Option have to do with decimal places and
formatting?

Are you perhaps setting decimal places at Tools>Options>Edit "Fixed decimal
places"?

Not the place to be doing that. That will divide your numbers by two when
entering them.


Gord Dibben MS Excel MVP

On Thu, 22 Jun 2006 00:49:29 +0200, "Franz Verga" <fra68ve@InVento.it> wrote:

>Nel post news:BF42EE91-CFCB-460A-A9A5-7040B631E622@microsoft.com
> *kpike* ha scritto:
>
>> I am creating a spreadsheet that includes currency values and would
>> like to maintain two decimal places for ease in data entry. The same
>> sheet includes a series of ticket numbers for which I want no decimal
>> at all. I cannot find a way to keep both of these functions on the
>> same sheet. I have had to reapply the tools option every time I get
>> to these cells. Is there an easier way to make it stick?
>
>
>Maybe you can use Data Validation...