Decimals

[TheMadTree]

Good afternoon,

I was wondering if there's any way to conditionally format a cell to display two decimals only if the value in that cell has decimals?

Any input would be greatly appreciated!

Thank you,

Elias

 

[FormR]

Using the "with a formula" method, you could try, for example.

=A1<>INT(A1)

 

[Tommeck37]

hello,

The way to do it which I know is through VBA. How? Check if third character from right is "." if so then copy first two characters from right.
I would use "RIGHT" function.

Please attach the file with data so I can write a code for it

Kind Regards
Tommeck37

 

[TheMadTree]

Good afternoon,

Thank you for your quick answer! I have ran a quick test and this solves my issue!

Have a nice day!

Elias