# 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!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## 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