Results 1 to 6 of 6

Thread: Export to Excel 8.0 displaying $ instead of £ sign!!

  1. Aug 24th, 2006, 09:23 AM #1
    vdillum
    vdillum is offline

    Thread Starter
    New Member
    Join Date
    Aug 2006
    Posts
    11

    Export to Excel 8.0 displaying $ instead of £ sign!!

    Hello,
    I am having a problem in displaying the currency symbol when I export a report to Excel format (excel 8.0 extended). On the report it is displaying £ sign which is what I want. But when I export it to excel, is is showing $ sign.I want the excel also to display the £ sign.
    Any idea how this can be sorted out...
    Please help
    Thx
    Reply With Quote Reply With Quote
  2. Aug 24th, 2006, 02:39 PM #2
    Al42
    Al42 is offline
    PowerPoster
    Join Date
    Feb 2006
    Location
    East of NYC, USA
    Posts
    5,691

    Re: Export to Excel 8.0 displaying $ instead of £ sign!!

    How is the excel column defined? What is the localization of the particular computer?
    The most difficult part of developing a program is understanding the problem.
    The second most difficult part is deciding how you're going to solve the problem.
    Actually writing the program (translating your solution into some computer language) is the easiest part.
    Please indent your code and use [HIGHLIGHT="VB"] [/HIGHLIGHT] tags around it to make it easier to read.
    Please Help Us To Save Ana
    Reply With Quote Reply With Quote
  3. Aug 24th, 2006, 02:54 PM #3
    RobDog888
    RobDog888 is offline
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Export to Excel 8.0 displaying $ instead of £ sign!!

    Please do not create duplicate threads across forums.

    http://vbforums.com/showthread.php?t=423978
    VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    • Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6
    Reply With Quote Reply With Quote
  4. Aug 25th, 2006, 09:28 AM #4
    vdillum
    vdillum is offline

    Thread Starter
    New Member
    Join Date
    Aug 2006
    Posts
    11

    Re: Export to Excel 8.0 displaying $ instead of £ sign!!

    Hello,
    I am having a problem in displaying the currency symbol when I export a report to Excel format (excel 8.0 extended). On the report it is displaying £ sign which is what I want. But when I export it to excel, is is showing $ sign.I want the excel also to display the £ sign.

    I have checked the regional options setting of my PC (control panel) where the currency symbol is £ and even in the report it is £ sign. But still the excel shows the $ sign. The default locale is set to UK.
    Any idea...
    Please help
    Reply With Quote Reply With Quote
  6. Aug 25th, 2006, 02:06 PM #5
    RobDog888
    RobDog888 is offline
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Export to Excel 8.0 displaying $ instead of £ sign!!

    You still havent said how you get the symbol in CR to display that way. You can not just paste in a special character and expect Excel to translate it.

    Excel also uses the Windows locale version so if your not running a multilanguage or or version compatible to your region then Excel will still display the $ sign. To use a different identifier you will need to reformat the resulting Excel sheet or automate Excel to open a file using a special locale number.
    VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    • Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6
    Reply With Quote Reply With Quote
  7. Aug 29th, 2006, 03:46 AM #6
    vdillum
    vdillum is offline

    Thread Starter
    New Member
    Join Date
    Aug 2006
    Posts
    11

    Re: Export to Excel 8.0 displaying $ instead of £ sign!!

    Hello,

    For all the fields if I want to display the £ sign, in the Format editor of crystal report, I have selected the System Currency default format and when I clicked on customize and in custom style form for currency,I put the symbol to be £.
    As for the Excel version, it is Microsoft Excel 2003 (11.8033.8036) SP2.
    Do you mean I have to reinstall another version of excel (a multilanguage one) in order to display the £ sign??

    Thx
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width