Please Help Me !!! Excel + VB 6 + MySQL

Originally Posted by Marius

Hi Everyone !!

I have the following problem:

I made an application using VB 6 + MySQL, working fine, however, when I try to export data to an Excel 2003 Worksheet, numeric values tend to "go bananas". Example:

I have TWO equal values (75) in the same row of data. When exporting to Excel, I have to divide /100 the values for presentation purposes, one of them turns out as 0.74, and the other one as 0.75 (Using the same procedures on both of them).

Also, for example when using a value of 100 (1.0 when divided), in the Spreadsheet, its value is: 100.05, or if rounded, 101.

Is there a reason for it, or better yet ... a workaround ???

Thank you in advance. Greetings,

Mario

Hi,

to explore your numbers, try setting the cell display to a number of decimal places, to see the actual values being imported.

If 100.05 rounds to 101 I would ask what 'rounding' you are using,
100.5 would round to 101.

for further help please post a short sample sheet.

hth
---