ok thank you got just pulled out the percent format and * by 100. works perfectly.