Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2000
Excel typically stores the actual number, regardless of format, UNLESS you
have applied the toolsoptions selection to "precision as displayed". Just tested with 1/12 dispalyed as %, general and number set to 2 deciaml places. multiplied by 100 which returned 8.33333333 in each case. "MaxiMai" wrote: Working with a worksheet that has payroll calculations. Some cells that are included in the calculation has % formating, which is some cases causes the # seen in the cell to round up. Can that be stopped? I do not want the figure to round up at all. I also do not want to show all the digits by increasing the decimal point. Again, can this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open 2000 file attachments in Excel 2000 | Excel Discussion (Misc queries) | |||
I cannot edit cell format in Excel 2000 (Part of office 2000)! | Excel Discussion (Misc queries) | |||
Using Excel 2000 as Data source for Word 2000 document | Excel Discussion (Misc queries) | |||
Hyperlink in Excel 2000 can't open bookmarked Word 2000 file | Excel Discussion (Misc queries) | |||
Excel Programs developed in Office 2000 on Windows 2000 | Excel Discussion (Misc queries) |