Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why do my numbers keep going down decimal places? | Setting up and Configuration of Excel | |||
Why do my numbers keep going down decimal places? | Setting up and Configuration of Excel | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
excel-enter integer number and get two decimal places | Excel Discussion (Misc queries) | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) |