| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
