Extracting to excel

[pa_broon74]

Hey folks.

How about this one

I'm extracting a Crystal report into excel and all the monetary values
are coming up as Dollars, under format - format cells it's set to £
and the crystal report itself is in £'s...

The user is running windows XP on a laptop, is there anything that I
should look at in excel or during the export process? No one else's PC
does this, just his.

He's my boss, I think he likes to test me

Any help greatly appreciated.

Thanks

 

[Guest]

Have you checked the regional & Language settings in the control panel. I
know these settings can affect some parts of office
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

 

[pa_broon74]

Yup, we checked this and its set to £'s

Thanks

 

[pa_broon74]

Yup, we checked this and its set to £'s

Thanks

FYI on the off chance that anyone else has this problem (unlikely I
know...)

Apparently this is a program glitch between XP and Crystal reports, it
is as yet unresolved.

Wonder what it'll do in Vista??