Format cells in the data sheet

[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

 

[Steve Rindsberg]

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??

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.

 

[black_sun]

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:

 

[Steve Rindsberg]

Denis,

By "datasheet graph" is this an MSGraph chart (do the PPT menu options change when
you doubleclick it?) or an inserted table?

 

[black_sun]

Hi,
it's a MSGraph Chart.. not a linked Excel file.

Thanks.
Denis


Steve Rindsberg ha scritto:

 

[Steve Rindsberg]

Hi,
it's a MSGraph Chart.. not a linked Excel file.

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?