Crystal Reports – How to format number fields

The following steps show how to change the formatting of a number field in Crystal Reports – for example, to remove decimal places, add a currency symbol or add a negative symbol.

  1. Right-click on the field and then click on ‘Format Field’
  2. On the ‘Number’ tab you’ll find all the number specific formatting options.
  3. To remove decimal places – select the (1123) style from the list
  4. To add a currency symbol – tick ‘Display Currency Symbol’
  5. To turn the value into a negative (display a minus symbol) – select the most appropriate style from the list.
  6. Click ‘OK’ to save your changes.