Values being formatted differently when opening spreadsheet using ado.net

[Joe]

I have a some-what simple app for importing data from excel to our database.
The app is written in C# and uses ado.net.

When I open the xls file, it displays in a grid to show the values.

The problem is values are formatted differently depending on the machine.

I have 2 machines. One the first one (excel installed) I open the xls file
and all values display as decimal even though in excel there displayed as
percents. This is fine and how I want it.
On the second machine (excel not installed) the values display as percents.

What can cause the difference in formatting?

Thanks,
Joe

 

[onedaywhen]

I open the xls file
and all values display as decimal even though in excel there displayed as
percents.

How are you opening the xls file without Excel? Using a viewer?
ADO.NET?

Jamie.

--

 

[Joe]

I'm opening it in a DataGrid.

How are you opening the xls file without Excel? Using a viewer?
ADO.NET?

Jamie.

 

[onedaywhen]

I'm opening it in a DataGrid.

You may be showing it in a gid but how are you accessing the data in
the xls: ADO.NET, COM automation, etc? Posting some code may help us.

Jamie.

--