Results 1 to 2 of 2
  1. #1

    Export to Excel Query

    Is there a specific query format to convert characters to numbers before exporting? I am having trouble converting in excel using vba. Any help is greatly appreciated.

  2. #2

    Re: Export to Excel Query

    Not sure exactly what you're trying to achieve.
    In excel you can use the CHAR() function.

    Example (just copy and paste this into a cell in Excel and select [ENTER]):
    ="Exchange Rates Graph of Pound (" & CHAR(163) & "), Euro (" & CHAR(128) & ") and Dollar (" & (CHAR(36) & ")")

    It will return:
    Exchange Rates Graph of Pound (), Euro () and Dollar ($)

    And if you need to know what CHAR is for a specific value you can use CODE() function.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
BetaSoft Inc.
All times are GMT -8. The time now is 05:30 PM.

Copyright BetaSoft Inc.