Get a number froma range with the number format

Question

I need to retrieve a number from a cell with the format e.g. cell A1 contains the number "001", but when I apply that to a variable it becomes "1". How do i retrieve "001"??

Tgtval = Range("A1")

Answer 1

Try using the Text property:

Tgtval = Range("A1").Text