Range text vs Range value
 

I have an excel file that is filled with zero padded numbers. If I
pull this info from the cell level with the Text method, (eg.
cell('C1').Text) I get '0002124'.

What i want however is a range (eg. range('A2', xlLastCell)). This
gives me values like 2124.0 instead of '0002124'. I know that
range('A2', xlLastCell).Text doesnt work, is there anything that does?

TIA
paqo