Which key is used to preserve leading zeros while entering number?
Answers
Answered by
1
Answer:
Select a blank cell, and type this formula =CONCATENATE(A1, B1,C1), press Enter key, then you can drag the autofill handle to fill this formula to the range you need. Tip: 1. You also can use this formula =A1&B1&C1 to combine cells and keep the leading zeros.
Similar questions