Excel help needed

[#1]

Remember to post this in the excel forum as well!!

Adam

[#2]

Thanks, I have solved the issue.

[#3]

Great! Please feel free to post the solution here as well :)

[#4]

The easiest way is as follow :- 

example :- 
=E27-TRUNC(E27)