Ironman
Well-known Member
- Joined
- Jan 31, 2004
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
Hi
I'm using a custom number format #"lb" so it looks like the below. But I just can't figure out how to amend it so where the value is zero, it shows "0lb", not "lb".
Help appreciated, thank you!
I'm using a custom number format #"lb" so it looks like the below. But I just can't figure out how to amend it so where the value is zero, it shows "0lb", not "lb".
-3lb |
-15lb |
lb |
Help appreciated, thank you!