excel table to powerpoint maintaining formats

[zorgaem]

Hi,

newb here. have written a macro to copy excel data from a range of cells to powerpoint. However, in powerpoint, the number formats are completely lost. For eg. some cells show values like 1345.9884940. I would like to have a "#,##0" format in the number cells - how can i do this?

any suggestions will be welcome

[dflak]

I wrote something like this for a "fixed template" PowerPoint. If you can't use it directly, then you can look at the code. The cells are copied over as a metafile (picture) rather than text and numbers.

The application is "fill in the blanks." With a properly named table, you should not have to change the code.

https://www.excelforum.com/tips-and-...rom-excel.html.

[zorgaem]

Thanks...tried it - but this seems to cut an image for the table as well. My routine takes the table range, converts it into text and pastes the text in a powerpoint table - that is where I have trouble with the number format. am able to change the fonts, alignment, etc, but there is no way of identifying if the data in a cell (in powerpoint) is a number and therefore it should follow the format of "#,##0". Any help with this would be much appreciated.

[dflak]

Yes, my code makes an image of everything.

You may have to put Format(value,"#,##0") in the code. In other words, copy the formatted string to where you want it in PowerPoint.