|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 27th, 2008, 01:14 AM
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
March 27th, 2008, 07:12 AM
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
March 27th, 2008, 09:36 PM
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!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
