Custom Number Format

[klynshoe]

Hello,

I am trying to create a custom number format. Basically I want the same format at the "General" setting, but where zeros are "-" like in the accounting format.

Examples
20.5 -->20.5
18 -->18
0 --> -

I am using EXCEL 2013. Any suggestions would be appreciated. Thanks,

Kelly

 

[63falcondude]

Maybe this helps you.

https://support.office.com/en-us/ar...o-values-3ec7a433-46b8-4516-8085-a00e9e476b03

 

[Jonmo1]

Try

General;General;-

 

[klynshoe]

Perfect, thank you!

Maybe this helps you.

https://support.office.com/en-us/ar...o-values-3ec7a433-46b8-4516-8085-a00e9e476b03

 

[klynshoe]

This works great too!!! Thanks!!

Try

General;General;-