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?

Nel post
*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

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

Your ticket number cells can be formatted for no decimals.

FormatCellsNumberNumberDecimal 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 ToolsOptionsEdit "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" wrote:

Nel post
*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...