• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Custom Format

Ana Dsouza

New Member
Hi,
Please help me in solving below query

Data :
state​
Brand​
Val​
Brand & Val (And Formula - "Brand & Val")​
ASSAM​
Arrow​
78.44​
Arrow - 78.443217138​

i want the output "Arrow - 78.44" (numbers in 2 decimal only) , i have tried with custom formatting but it did not work.


Regards,
Ana
 

vletm

Excel Ninja
Ana Dsouza
Have You used 'Val's value 78.44 ( ~C2) with Your right side output?
You could eg use Round(C2,2) instead C2 to get Your needed output.
 

vletm

Excel Ninja
Ana Dsouza
I do not start to guess Your sheets layout.
But ...
If Your Cell B2 value is Arrow
If Your Cell C2 value looks like 78.44
... then Your D2 formula could be = B2 & " - " & Round(C2,2)
 
Top