Format cells in the data sheet

  • Thread starter Thread starter black_sun
  • Start date Start date
B

black_sun

Hi,
I have this problem: when I copy and paste from Excel to PowerPoint
(with VBA) the cells format changes.
In Excel are numbers but in PPT are text....How can I change this
situation as with this values I make a chart??

Thank in advance....

Cheers,
Denis
 
Hi,
I have this problem: when I copy and paste from Excel to PowerPoint
(with VBA) the cells format changes.
In Excel are numbers but in PPT are text....How can I change this
situation as with this values I make a chart??
Click to expand...

Which version of PowerPoint?

And ... you're pasting from a selected range of data in Excel (?) to what in
PPT? A slide? An existing graph's data table?

If a slide, then it'll always be text. PowerPoint doesn't do numbers. VBA can
convert the text-that-looks-like-numbers back into numbers if need be, though.

It all depends on where you're going with the data.
 
Hi Steve,
I work with 2003.
I copy a selected range in excel into a datasheet graph which is
inside a slide.
How can I convert value?

Thanks
Denis

Steve Rindsberg ha scritto:
 
Denis,

By "datasheet graph" is this an MSGraph chart (do the PPT menu options change when
you doubleclick it?) or an inserted table?
 
Hi,
it's a MSGraph Chart.. not a linked Excel file.

Thanks.
Denis


Steve Rindsberg ha scritto:
 
Hi,
it's a MSGraph Chart.. not a linked Excel file.
Click to expand...

OK. Normally, MSGraph wants to treat everything past the first column and row as
numbers. If text appears in any of the other cells in the table, Graph treats it as
zero. Is that what's happening?
 
Back
Top