I have a userform that I have the user input some information on. Some information is sensitive, so I have only the last five digits show. This part I have down fine. The problem is that when storing the last five digits, sometimes the numbers begin with zero's. I can't get Excel to quit dropping those zero's, even if it is stored as text. Right now I have been using one of these two:
Any help is appreciated.
Code:
field1 = .range("A" & i).text
.range("B" & i) = format(field1, Text)
or
.range("B" & i) = format(field1, "@")
Any help is appreciated.