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

Report •

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?

Report •

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

Report •

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.

Report •
Related Solutions

Ask Question