Excel 'nil'

Options
System
System Posts: 100,534 🤖 Admin 🤖
edited June 18 in General member discussion
Does anyone know how I write nil in a cell as - ?

Thanks.
Simon

Comments

  • System
    System Posts: 100,534 🤖 Admin 🤖
    Options
    Re:Excel 'nil'

    To right nil as '-' you need to set the correct format. The easiest option is to use the ',' format which defaults nil as '-'.

    If this causes problems you will have to use format cells and probably a custom setting to get it as you want it.

    Hope this helps !
  • System
    System Posts: 100,534 🤖 Admin 🤖
    Options
    Re:Excel 'nil'

    If you set the number formats to accounting in the format cells option it puts in the 000, and also the nil as -. you can set it so it doesn't use a currency symbol and that it dispays to 2 decimal places.
  • System
    System Posts: 100,534 🤖 Admin 🤖
    Options
    Re:Excel 'nil'

    Thanks ever so much!

    Simon
  • System
    System Posts: 100,534 🤖 Admin 🤖
    Options
    Re:Excel 'nil'

    #,##0.00 ;(#,##0.00);-

    That's the custom format I would generally use.

    2 decimal places, brackets around negative numbers and '-' instead of 0.00.

    I also put two spaces after the '-' so that it moves it along a bit rather than being right against the cell edge.

Categories

Privacy Policy