Get instant live expert help on How do I can decimals be integers
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Please may I have assistance with creating a formula that will round up any decimal value however will not round any integers. The cells are formatted to not show any decimals.
Example:
2.000001 rounds up to 3
2.000000 remains as 2
Solved by G. H. in 28 mins
In cell S16, the formula should return "True" but it shows false. I think it may be Decimals. can we fix this so it shows true.
Solved by B. D. in 20 mins
Hi i need the custom format for display of numbers in lakhs with two decimals and negative numbers in brackets. for eg -123456789.00 to be displayed as (1,234.57). Can this be provided
Solved by B. S. in 11 mins
I use Excel in Office 365. When I enter a calculation in a cell, the cell being formatted at %, Excel automatically expands the numebr decimals and widens the column width. How can I stop this? I notices when I look into number formats, custom formats there is a custom % format with over 10 decimals. I deleted this custom format. The I entered the same calculation and again Excel expands the decimals and widens the column. When I check custom number formats, Excel has added back the % format with over 10 decimals. How can I stop Excel from adding decimals and widening the column?
Solved by C. C. in 17 mins
I'm looking for a way to round up integers by multiples of 6. Ect
6 would be 6
7 Would be 6
.
.
.
11 Would be 12
12 Would be 12
Solved by E. A. in 23 mins