Crystal Reports – How to format number fields

by

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’
  3. On the ‘Number’ tab you’ll find all the number specific formatting options.
  4. To remove decimal places – select the (1123) style from the list
  5. To add a currency symbol – tick ‘Display Currency Symbol’
  6. To turn the value into a negative (display a minus symbol) – select the most appropriate style from the list.
  8. Click ‘OK’ to save your changes.