Excel help in vb6

I have a program where I import a "CSV" file into excel. I then save it to a "XLS" file and open it with msflexgrid.
After saving it to the "XLS" file I manually open it in excel to check it. In one column some of the entry's are text and 3 of them are only numbers. The three columns with only numbers are right justified. (Standard for Excel). However when I read them in the msflexgrid it deletes the numbers. I can't format the cell in Excel as it won't carry it to the msflexgrid and actually gives me an error.
Why won't it read them ????

Please help me before I snap

Welcome to forums! :wave:

If you already have csv file then you don't need to save it in excel format to load flexgrid.
There are many samples posted demonstrating how to use flexgid - some of them can be found here.