Problem with data format in Excel

[fm2005]

Hi, I am moving some data from an Access database to an Excel file with:

oXLSheet.Range("A2").CopyFromRecordset rstExcel

I am having some troubles with the format data is displayed. With the columns that are "Date/Time"data type in the Access database I put:

oXLSheet.Columns("A:A").NumberFormat = "dd/MM/yyyy hh:mm:ss"

in the visual basic code to move them in the correct format, and it works ok. But there are other columns that are "Number" data type in Access and when I move them to an excel file they appears like "27/02/1900"
(I think 00/00/1900 corresponds to 0). I don´t understand why the program considers this data as dates instead of numbers. I have tried:

oXLSheet.Columns("B:B").NumberFormat = "0"

but it doesnt work. How could I get the data in the correct format? I have other columns in Access that are "Number" data type and they appear correctly in the Excel file Thank you very much for your help!!

[si_the_geek]

Moved to Office Development

What kind of values are in the column(s) that arent shown properly?

What happens if you try this format instead:

oXLSheet.Columns("B:B").NumberFormat = "General"

[fm2005]

I have tried what you said:

oXLSheet.Columns("B:B").NumberFormat = "General"

but the data is displayed again in the "27/02/1900" format. The values in these columns (I have 2 problematic columns) are numbers (positive integers), I can see them correctly if I open the Access database. In the table design the data type for these 2 columns is "Number". The most annoying thing is that I have other columns with the same data type and they are shown correctly in Excel. Moreover, sometimes the 2 problematic columns are shown correctly, but other times no (I don´t know why) so I would like to force these data to be displayed always in the correct data format if possible. Thanks for your help!!