Results 1 to 6 of 6

Thread: Changing numbers with scientific notation (E+) in pivot table created by VBA

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 07-24-2020, 01:16 AM #1
    crabmanrocks
    crabmanrocks is offline
    VBAX Newbie
    Joined
    Jul 2020
    Posts
    3
    Location

    Question Changing numbers with scientific notation (E+) in pivot table created by VBA

    My pivot table created by a VBA Macro is not displaying the account numbers in full. It summaries them with a scientific notation.

    What VBA code can I use in the macro to force it to fully display the number irrespective of which PC it's run? Code of Macro & sample data is shown in the tabs of the attached file.
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this 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