Excel Linking and Number Format Issues

  • Thread starter Frustrated Power Point User
  • Start date
F

Frustrated Power Point User

Hi -
I have a monthly report where the numbers are Power Point slides are linked
over to excel. Some of these numbers are percentages which show to 1 decimal
place in excel. However when the data comes over to PP - the default is 2
decimal places. If I change the format in excel - it only gets overwritten
when I update the links in excel again.

Is there a quicker way than going into each chart and reformatting the
numbers each month? I was thinking a macro or a function in excel to fool PP?

Any advice would be appreciated.

Thanks!
Mary
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Found few bugs in my daily routine of work in excel for MAC 0
Found few bugs in my daily routine of work in excel for MAC 0
How to count the numbers in a Word document? 0
Merging from an Excel file with graphics 1
Pasting a Table from Excel to PP: please help! 1
Embed the same Excel multiple times 0
Linking Excel numbers in PPT text & slides? 2

Top