I have an Access application that has to compare two spreadsheets. We are
phasing out one system and replacing it with another.

I compare the 2 spreadsheets line by line, and cell by cell.

The spreadsheets appear identical when opened. However, upon closer
inspection I see:

Sheet Value Fomat What you see

Old .154 Percent (2 decimal places) 15.4%
New 15.4% None 15.4%


I can take the old value multiply by 100. However, is there a way I can
get the "formatted" value of a cell?