We have been getting an Excel file from a vendor that had numbers in a
General format. This worked great for our purposes (exporting to Access).

Example:
Actual contents of A1: 58.36
Display of A1: 58.36
This is what we want....

This time around the file has been sent to us and the numbers are not in
General format, but a Custom format that looks like this:

[=0.0416666666666666][h]:mm:ss;[m]:ss

Actual contents of A1: 12:05:29 AM
Display of A1: 5:29
We want the display of 5:29 to be the real contents of the cell. Not the
time format that is currently there.

When we change the format to General, we get:

Contents of A1: 12:05:29 AM
Display of A1: 0.00380787
So, just changing it to General isn't the 'magic' that we need.

Any ideas?

BTW: The vendor is disavowing any knowledge of their actions! We are still
trying to work with them.

TIA!