Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
every time i type a number with a decimal piont ie 22.5 it rounds the figure
up to next highest ie23 - why |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I get excel to stop rounding numbers | Excel Discussion (Misc queries) | |||
Excel won't stop rounding numbers. Please help | Excel Discussion (Misc queries) | |||
How do I stop excel from rounding numbers? | Excel Discussion (Misc queries) | |||
How do I stop numbers from rounding in Excel? | Excel Discussion (Misc queries) | |||
Rounding off numbers in Excel 2003 | Excel Worksheet Functions |