ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   why does excel keeping rounding numbers (https://www.excelbanter.com/excel-discussion-misc-queries/175270-why-does-excel-keeping-rounding-numbers.html)

babblings

why does excel keeping rounding numbers
 
every time i type a number with a decimal piont ie 22.5 it rounds the figure
up to next highest ie23 - why

FSt1

why does excel keeping rounding numbers
 
hi
check your formatting to see if the format is number with decimal places = 0

regards
FSt1

"babblings" wrote:

every time i type a number with a decimal piont ie 22.5 it rounds the figure
up to next highest ie23 - why


Dave Peterson

why does excel keeping rounding numbers
 
If the format of the cell is General and the column is too narrow, excel will
show what it can.

Try widening the column or using a smaller font.

babblings wrote:

every time i type a number with a decimal piont ie 22.5 it rounds the figure
up to next highest ie23 - why


--

Dave Peterson

babblings

why does excel keeping rounding numbers
 


"FSt1" wrote:

hi
check your formatting to see if the format is number with decimal places = 0

regards
FSt1

"babblings" wrote:


Thanks for the help

every time i type a number with a decimal piont ie 22.5 it rounds the figure
up to next highest ie23 - why



All times are GMT +1. The time now is 03:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com