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 |
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 |
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 |
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