Make excel only display two decimal places

I've tried various things and nothing is working out quite like it should. I've used the office button, excel options, advanced, and set the automatic insert decimal place to 0'. Then I tried the format cells, and set the decimal places to 2 method. Nothing gives me what I want. I either end up with whole numbers with two decimal places e.g. 23.00 or when i enter 5.23 into a cell I only get '23' showing up.

Is there a way to show whole numbers without decimal places and have excel never show more than 2 decimal places in non-whole numbers?

Answers


You can format the cell to display maximum of 2 decimal places (and none for whole numbers) by applying the format 0.## in FormatCells -> Number Tab -> Custom -> Type. See this conversation for more details


Need Your Help

Typhoon DI on storyboard integration

ios objective-c xcode swift typhoon

I'm new to Typhoon. I'm reading documentation to inject dependencies into my storyboard's view controllers. I have basic understand of how the framework does the DI on classes, but storyboards seems