NumberMuncher
New Member
- Joined
- Jul 20, 2015
- Messages
- 16
- Office Version
- 365
- Platform
- Windows
Hi,
I have a column that is merged and the format currently is xxxxx-* because column 1 is 5 digits and column 2 is either 1 or 2 digits.
How do I format this merged column to have a fixed format of xxxxx-xx with a 0 for blank?
Thank you for your help!
I have a column that is merged and the format currently is xxxxx-* because column 1 is 5 digits and column 2 is either 1 or 2 digits.
How do I format this merged column to have a fixed format of xxxxx-xx with a 0 for blank?
Thank you for your help!