Thread: Comparing two spreadsheets

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?

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



"Alex Lifeson" <ALife74@Yahoo.com> 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?

Alex,

Why reinvent the wheel? Have a look at www.synkronizer.com
It's a commercial excel addin for file comparison.
(co-authored by me

Although personally I'd ignore the difference stated in your example.
as the values are equal, only formatted differently .


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Alex Lifeson wrote :

> 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?