I am making an attempt to make a conditional formatting method that eliminates decimal places after a amount exceeds a certain value, independent of regardless of what accounting forex style is in effect. I am unable to use VBA for this software. The column width is for the complete text, http://brookseebys.shotblogs.com/qatar-business-directory-in-excel-format-no-further-a-mystery-18865317