Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimals rounding up
I am inputting data into the cells numbers with decimals in them and some of
the cells, not all, are rounding up my decimals and I don't want that. Does anyone know how to fix this or stop this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimals rounding up
I am inputting data into the cells numbers with decimals in them and some
of the cells, not all, are rounding up my decimals and I don't want that. Does anyone know how to fix this or stop this? What happens if you format the cells in question as General? Rick |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimals rounding up
Widen the cells so that they are wide enough to show the number of decimal
places you've entered. -- David Biddulph "Cynthia" wrote in message ... I am inputting data into the cells numbers with decimals in them and some of the cells, not all, are rounding up my decimals and I don't want that. Does anyone know how to fix this or stop this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimals rounding up
Hi,
Do the following: 1. On the Tools menu, click Options. The Options dialog is displayed. 2. Click the Edit tab. 3. Under the Setting section, select the Fixed decimal check box and click the arrow to increase or decrease the decimal place you want to view in the worksheet cell format. 4. Click OK to save the settings and return to the worksheet. Challa Prabhu "Cynthia" wrote: I am inputting data into the cells numbers with decimals in them and some of the cells, not all, are rounding up my decimals and I don't want that. Does anyone know how to fix this or stop this? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimals rounding up
Am I confused? I thought that the "fixed decimal places" option under
Tools/ Options/ Edit was the one which didn't cause rounding of decimals but actually shifted the decimal place, and should therefore normally be avoided? If 2 decimal places are set under "fixed decimal places", then entering 12345 gives you a number of 123.45 Which version of Excel causes "fixed decimal places" to behave in the way you describe, Challa? -- David Biddulph "challa prabhu" wrote in message ... Hi, Do the following: 1. On the Tools menu, click Options. The Options dialog is displayed. 2. Click the Edit tab. 3. Under the Setting section, select the Fixed decimal check box and click the arrow to increase or decrease the decimal place you want to view in the worksheet cell format. 4. Click OK to save the settings and return to the worksheet. Challa Prabhu "Cynthia" wrote: I am inputting data into the cells numbers with decimals in them and some of the cells, not all, are rounding up my decimals and I don't want that. Does anyone know how to fix this or stop this? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimals rounding up
Hi,
I mistook took the question. I apologize. I am wrong. Challa Prabhu "David Biddulph" wrote: Am I confused? I thought that the "fixed decimal places" option under Tools/ Options/ Edit was the one which didn't cause rounding of decimals but actually shifted the decimal place, and should therefore normally be avoided? If 2 decimal places are set under "fixed decimal places", then entering 12345 gives you a number of 123.45 Which version of Excel causes "fixed decimal places" to behave in the way you describe, Challa? -- David Biddulph "challa prabhu" wrote in message ... Hi, Do the following: 1. On the Tools menu, click Options. The Options dialog is displayed. 2. Click the Edit tab. 3. Under the Setting section, select the Fixed decimal check box and click the arrow to increase or decrease the decimal place you want to view in the worksheet cell format. 4. Click OK to save the settings and return to the worksheet. Challa Prabhu "Cynthia" wrote: I am inputting data into the cells numbers with decimals in them and some of the cells, not all, are rounding up my decimals and I don't want that. Does anyone know how to fix this or stop this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding decimals in a summ | Excel Discussion (Misc queries) | |||
Rounding Up Decimals | Excel Worksheet Functions | |||
Rounding Decimals | Excel Discussion (Misc queries) | |||
Rounding results to nearest quarter (in decimals) | Excel Discussion (Misc queries) | |||
Rounding Decimals | Excel Worksheet Functions |