Hi...I have data similar to this:
8000
8001-1952
8520-1234
8010
I need a formula to make all my numbers into the same format. Any number without the ending (-####), I need to convert to -0000 as shown below. What would be the correct formula? I tried using the Format Function, but it keeps adding the Zero's in front of the number instead of behind the number.
8000-0000
8001-1952
8520-1234
8010-0000
Thank you in advance!!