Singular & Plural
Here's a way to show singular or plurals as a Custom Format. (Just enter the number and the singular or plural will appear automatically)
[=1]0 "Pallet";[>1]0 "Pallets";General
or
[=1]0 "Carton";[>1]0 "Cartons";General
etc.
© Copyright
andrewsexceltips.net
All Rights Reserved.