CODEWITHSUNDEEP
excel
Hola
Hola

Reputation: 95

Reference cell not showing values in 1 decimal or 2 decimal places

I'm taking a reference from a cell M7 which has a value 30.0

the cell B2 has a reference to cell M7 as =M7 & " mtr."

The result displays as 30 mtr., but what I want is to show it as 30.00 mtr. or 30.0 mtr.

Is there any workaround for this?

Upvotes: 0

Views: 569

Answers (1)

ashleedawg
ashleedawg

Reputation: 21619

This is not a programming question.

...but you can use the TEXT function, like: 

=TEXT(M7,"0.00") & " mtr."

See this link for more about the function. SuperUser is probably a better place for questions about how to use Excel.

Upvotes: 1

Related Questions