A
Alex Lifeson
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?
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?