Is it anyway to setup a cell (Format/Cells/Number/Custom) so when the
number is a whole number, it shows as a whole number and when a number
has a decimal, it shows as a decimal? For example our system has an
eight digit number as the following:

12311001
12412002

They show as:

123-11-001
124-12-002

When we add a mod 1, 2 etc. to the existing number we want it to show
the following:

123-11-001
123-11-001.01
123-11-001.02
124-12-002
124-12-002.01

I'm trying to keep it from adding the 2 zeros to the end of the
original number like the following:

123-11-001.00

Any help would be greatly appreciated.
Darrell