Hi guys,
I was calculating costs and I notice the amounts in column D are correct but its calculated in correctly in cell N2 when referenced? I broke the calculation down in columns L through O. My other question is, I have the column D amounts formatted as Accounting, why does it show the .00 and if I remove it it is then formatted as Custom but the above two amounts are fine?
Thank you in advance if you can assist.
accounting default is 2 decimal places
you can change the decimals under formatting
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Ah yes, is there a way to only apply it zeros though?
i'm not sure , maybe under custom formatting
Thank you for your input!
how about when less that 1
https://chandoo.org/wp/excel-number-...conditionally/
This seems to work thank you for sharing this, I noticed it rounded the 14.65 though to 15. But it definitely removed the zeros and left 0.55 as is.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks