Alex,
I think you are looking for Range("A1").Text
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Alex Lifeson" wrote in message...
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?