CODEWITHSUNDEEP
excel-formula
user2153920
user2153920

Reputation:

How do I format MS Excel 2016 to show 2 decimals that is always 00

Can I somehow format the number column in Excel 2016 to show 2 decimals and they should always be .00

Upvotes: 0

Views: 44

Answers (1)

a-burge
a-burge

Reputation: 1574

Go to Format Cell -> Number (Ctrl + 1) and give the cell the custom format of 0".00". You'll notice that whenever the underlying number is .50 or greater, it will round up. To avoid this, use a rounddown function.

Note though that you are basically cheating by showing significance that isn't there...

Upvotes: 2

Related Questions