enter numbers without decimal places
 

I am try to enter a inventory list, with a three digit ID number, so it will
look as follows:

543 $12.99
544 $22.99

But what I get is .543, 5.4 .005, .5 etc....

How do I get it to display 543 not showing a decimal. (I know that
technically it is 543.0, but you know what I mean)

enter numbers without decimal places
 

Format the cells to 'General'
--
If this post helps click Yes
---------------
Jacob Skaria


"wt.pm" wrote:

I am try to enter a inventory list, with a three digit ID number, so it will
look as follows:

543 $12.99
544 $22.99

But what I get is .543, 5.4 .005, .5 etc....

How do I get it to display 543 not showing a decimal. (I know that
technically it is 543.0, but you know what I mean)

enter numbers without decimal places
 

So when you enter a number it automatically has decimals included. Assuming
that to be the case check

Tools - Options - Edit | Fixed Decimal | Uncheck
--
HTH...

Jim Thomlinson


"wt.pm" wrote:

I am try to enter a inventory list, with a three digit ID number, so it will
look as follows:

543 $12.99
544 $22.99

But what I get is .543, 5.4 .005, .5 etc....

How do I get it to display 543 not showing a decimal. (I know that
technically it is 543.0, but you know what I mean)

enter numbers without decimal places
 

Thank you Jim, I should have known that, but never would have thought about
it.

"Jim Thomlinson" wrote:

So when you enter a number it automatically has decimals included. Assuming
that to be the case check

Tools - Options - Edit | Fixed Decimal | Uncheck
--
HTH...

Jim Thomlinson


"wt.pm" wrote:

I am try to enter a inventory list, with a three digit ID number, so it will
look as follows:

543 $12.99
544 $22.99

But what I get is .543, 5.4 .005, .5 etc....

How do I get it to display 543 not showing a decimal. (I know that
technically it is 543.0, but you know what I mean)