Extracting to excel
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 |
Extracting to excel
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" wrote: 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 |
Extracting to excel
Yup, we checked this and its set to £'s
Thanks |
Extracting to excel
On 8 Feb, 14:42, "pa_broon74" wrote:
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?? :-) |
All times are GMT +1. The time now is 08:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com