happy monday my friends. I’m trying to do a mail merge using exel and have a list of numbers that I need to reformat to 4 characters. Meaning I have 1, 28, 444, and 1234 and I need them to show 0001, 0028, 0444, 1234. I thought I had it but foing and & function adding a couple 0’s and than doing a =right(ref,4), but its only picking up one zero. Any ideas of a function I could use??
ctrl1 - number - custom - enter 0000 in the “Type” field
Let A1 be your reference cell: =IF(LEN(A1)=1, “000”&A1,IF(LEN(A1)=2, “00”&A1,IF(LEN(A1)=3, “0”&A1,""&A1)))
LBriscoe Wrote: ------------------------------------------------------- > ctrl1 - number - custom - enter 0000 in the “Type” > field i <3 you 
LBriscoe Wrote: ------------------------------------------------------- > ctrl1 - number - custom - enter 0000 in the “Type” > field Cool trick! Thanks…