[RESOLVED] simple text box question

I have a text box linked to an excel spreadsheet. I see when viewing the spreadsheet in excel the cells with letters in them justify left and the cells with only numbers justify right. When these cells are linked to a text box in VB6 the cells with letters show up but the cells with only numbers doesn't. I can't format the cells in excel as they are built on the fly. Any suggestions what I'm doing wrong.

Never mind I found it. I set the max length on the text box to 3 and the number showed up and was used in the calculation. Thanks anyway