Keep trailing decimal number

[chunu]

Hi,
In below formula when i multiply both sides of a decimal number, its giving wrong result.
=LEFT(A15,2)*RIGHT(A15,2)

Cell A15 value is 29.14 =406 correct result
If value in cell A15 is 40.40 result should be 1600 but its giving 16
Please help.
Thanks

 

[Alex Blakenburg]

Assuming it is alway going to be 2 digits-period-2 digits, try

=LEFT(A15,2)*RIGHT(TEXT(A15,"00.00"),2)

 

[chunu]

Assuming it is alway going to be 2 digits-period-2 digits, try

=LEFT(A15,2)*RIGHT(TEXT(A15,"00.00"),2)

Thanks its working

 

[Alex Blakenburg]

Thanks for letting me know. Glad I could help.