+ Reply to Thread
Results 1 to 5 of 5

PowerPoint formatting: how do I separate '000 by space in the figures in data tables

  1. #1
    Registered User
    Join Date
    02-05-2014
    Location
    Prague, Czech Republic
    MS-Off Ver
    Excel 2010, Excel 2016
    Posts
    72

    PowerPoint formatting: how do I separate '000 by space in the figures in data tables

    Hi all,

    I would have one question regarding to the PowerPoint formatting. I've got a table on one sheet, that is populated by data from Excel (by using macro).

    What I would need is to make formatting consisent with the Excel file, meaning that figures copied over to the PowerPoint data table have thousand digits separated by space from the rest (e.g. 112 000).

    Would anyone have any suggestions. I'm interested in both manual adjustment or (and preferably) by using VBA coding.

    Thanks in advance!

  2. #2
    Registered User
    Join Date
    02-05-2014
    Location
    Prague, Czech Republic
    MS-Off Ver
    Excel 2010, Excel 2016
    Posts
    72

    Re: PowerPoint formatting: how do I separate '000 by space in the figures in data tables

    To elaborate, I'm filling the tables by the following macro, copying over the data from the enclosed xls. file into the ppt.:

    Please Login or Register  to view this content.
    Also, if anyone of you had the idea how to make this code more efficient, please let me know. The main obstacle seems to be, that I need to round only some specific cells (not all contains numbers).

    The possible solution, that crosses my mind might be, that I copied the content of the xls. cell not as a text to keep the formatting.

    Thanks!
    Last edited by lukelucky; 06-29-2015 at 11:38 AM.

  3. #3
    Registered User
    Join Date
    02-05-2014
    Location
    Prague, Czech Republic
    MS-Off Ver
    Excel 2010, Excel 2016
    Posts
    72

    Re: PowerPoint formatting: how do I separate '000 by space in the figures in data tables

    Here I'm adding some more progress. Apparentely, you can set up formatting of the number (below is the macro copying the data from MS Excel file to PPT table, 3rd row). The thing:

    HTML Code: 

  4. #4
    Registered User
    Join Date
    02-05-2014
    Location
    Prague, Czech Republic
    MS-Off Ver
    Excel 2010, Excel 2016
    Posts
    72

    Re: PowerPoint formatting: how do I separate '000 by space in the figures in data tables

    Here I'm adding some more progress. Apparentely, you can set up formatting of the number (below is the macro copying the data from MS Excel file to PPT table, 3rd row):

    HTML Code: 
    The problem is that the code that has been working in the previous file isn't working now for my current file. Thousands are not separated when the data are coppied over into PowerPoint deck.

    Could anyone of you tell my what might be causing it? What might be the differential factor? Alternatively, if anyone of you will use this code and it will be working for you, could you please share the experience?

    Thank you!

  5. #5
    Registered User
    Join Date
    02-05-2014
    Location
    Prague, Czech Republic
    MS-Off Ver
    Excel 2010, Excel 2016
    Posts
    72

    Re: PowerPoint formatting: how do I separate '000 by space in the figures in data tables

    Here I'm adding some more progress. Apparentely, you can set up formatting of the number (below is the macro copying the data from MS Excel file to PPT table, 3rd row):

    HTML Code: 
    The problem is that the code that has been working in the previous file isn't working now for my current file. Thousands are not separated when the data are coppied over into PowerPoint deck.

    Could anyone of you tell my what might be causing it? What might be the differential factor? Alternatively, if anyone of you will use this code and it will be working for you, could you please share the experience?

    Thank you!

    Source:
    https://support.office.com/en-nz/art...3-63b9cd842530
    Last edited by lukelucky; 07-08-2015 at 06:53 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro needed to Concatenate data in 2 separate tables of 2 separate sheets
    By 823 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 02-08-2015, 02:02 PM
  2. [SOLVED] Get figures from multiple data tables
    By MATU70 in forum Excel General
    Replies: 10
    Last Post: 11-03-2014, 08:42 PM
  3. Converting Figures with space at the end to Numbers
    By Muammar in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-15-2014, 11:42 AM
  4. Merging Data from Separate Tables
    By william. in forum Access Tables & Databases
    Replies: 2
    Last Post: 11-02-2012, 05:07 PM
  5. [SOLVED] moving average of figures from separate tables
    By Melissa in forum Excel General
    Replies: 15
    Last Post: 01-06-2006, 04:20 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1