What's the data source? Is it using a published data source? If it is, it could possible adopt the data source's formatting.
In which case, set some default properties or formatting in the workbook itself to override it.
the solution provided by Praveen Kumar is correct but if even then problem persists then use INT function if you want to show Number in whole number
if you want to show profit in text then make a calculated field with INT(Profit) and place it in text.