View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
challa prabhu challa prabhu is offline
external usenet poster
 
Posts: 663
Default 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?