Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2000
Do you mean that the value might be 12.6%, but this shows as 13% and
you want it to show as 12%? If that is the case then you will need to amend your formula that produces the percentage as follows: =ROUNDDOWN(your_formula,2) then copy this down the column if necessary. If you want to show 1 decimal place, then make it: =ROUNDDOWN(your_formula,3) Hope this helps. Pete On Oct 16, 6:48 pm, 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) |