Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Why do my numbers keep going down decimal places?
Whenever I post any number in Excell 2002 it goes down exactly two decimal
places and rounds. For example, I post 8 and it shows up as 0. Clicking the cell reveals that it has changed into 0.08. Please help! |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Why do my numbers keep going down decimal places?
It's probably just a fixed decimal setting
Click Tools Options Edit tab Uncheck "Fixed decimal" OK should get things back to normal -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Excell2002ishard" wrote: Whenever I post any number in Excell 2002 it goes down exactly two decimal places and rounds. For example, I post 8 and it shows up as 0. Clicking the cell reveals that it has changed into 0.08. Please help! |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
Why do my numbers keep going down decimal places?
You need to format the column. Click the column, right click, format cells,
then choose numbers, set the decimal place where you need it to be. "Excell2002ishard" wrote: Whenever I post any number in Excell 2002 it goes down exactly two decimal places and rounds. For example, I post 8 and it shows up as 0. Clicking the cell reveals that it has changed into 0.08. Please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum of numbers with only two decimal places wrong | Excel Discussion (Misc queries) | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
My numbers format as a number with two decimal places. | Excel Discussion (Misc queries) | |||
Adding numbers in a column that have 3 decimal places | Excel Worksheet Functions | |||
Entering numbers with variable decimal places. | Excel Worksheet Functions |