Solved How to format info in a cell

July 15, 2017 at 15:25:44
Specs: Windows 7
I have rounded currency info, but I need to have the excel sheet show only the rounded information in the cells, how can I make that happen?

See More: How to format info in a cell

Reply ↓  Report •

#1
July 17, 2017 at 05:54:05
Can you give an example for that?
How have you rounded the currencies? By using the cell formatting option?

Reply ↓  Report •

#2
July 22, 2017 at 16:10:53
yes, I used the format cell and adjusted decimal to 0

Reply ↓  Report •

#3
July 23, 2017 at 04:57:08
✔ Best Answer
You need to use the round function for the cell, because the format option is simply a visual thing, but the round option cuts the not needed numbers.
Lets say A1 is 1,2345
Set A2 =A1 and set decimal adjustment to 0
Set B2 =Round(A1,0)

Format A2 and B2 to decimal 4 or more.
You'll see the difference.


Reply ↓  Report •
Related Solutions


Ask Question