how to force 2 and always 2 decimals

Greyhawk

New Member
Joined
Oct 10, 2006
Messages
3
Hi,
i have a problem with my decimals in excel. I want 2 decimals, but eg. 50,50 turns to 50,5...how do i force the "0" in the end, so it stays 50,50?

regards
Torben
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

hayden

Board Regular
Joined
Sep 23, 2005
Messages
159
Right click on the cell with the value and then click on format cells. Next click on the number tab. Select number under category and then set your decimal places.

Hayden
 

hayden

Board Regular
Joined
Sep 23, 2005
Messages
159
So the value of the cell is 50,50 and not 50.50? You might need to use the round function?

hayden
 

Greyhawk

New Member
Joined
Oct 10, 2006
Messages
3
ahhh, think i found the problem....in my work i had to change the "," to "." at some point, and that might have caused the problem. because when i changed it back, it worked
 

Forum statistics

Threads
1,141,718
Messages
5,708,068
Members
421,543
Latest member
SGM

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top