I have date of birth data in columns ABC, with A and B formatted to show leading zeros.
Used the following formula to combine data into column D in a required format:
=A2&"/"&B2&"/"&"19"&C2
PROBLEM: the leading zeros in A and B are not showing up in the formula in Column D. Any solutions?
Used the following formula to combine data into column D in a required format:
=A2&"/"&B2&"/"&"19"&C2
PROBLEM: the leading zeros in A and B are not showing up in the formula in Column D. Any solutions?
A | B | C | D |
05 | 01 | 48 | 5/1/1948 |
05 | 04 | 68 | 5/4/1968 |
13 | 11 | 72 | 13/11/1972 |