I have EXCEL 2007 and want to import figures from a 2003 EXCEL spread sheet
whose figures are the result of other spread sheets of which I have no access.
My spread sheet does not "see" the imported figures even though I can see
them. (When I use my excel auto sum feature on the imported data, the
resultant column totals are zero.) Presently I am having to reenter the
imported data by hand into my spread sheet.
Is there a way to convert the imported figures to a form my excel can "see"
and enable me to manipulate the imported data?
buzz
--
Seamen, with their inherent sense of order, service, and discipline, should
really be running the world.

I would guess that the numbers are importing in as text (when you put the
cursor in the cell is there a ' before the number?)
The easiest way to correct this is to go 'tools'...'options'...'error
checking' and make sure 'number stored as text' box is checked off.

then go 'tools'...'error checking' and it will allow you to convert the
text numbers into regular numbers and thus do calculations.





"buzz" wrote:

I have EXCEL 2007 and want to import figures from a 2003 EXCEL spread sheet
whose figures are the result of other spread sheets of which I have no access.
My spread sheet does not "see" the imported figures even though I can see
them. (When I use my excel auto sum feature on the imported data, the
resultant column totals are zero.) Presently I am having to reenter the
imported data by hand into my spread sheet.
Is there a way to convert the imported figures to a form my excel can "see"
and enable me to manipulate the imported data?
buzz
--
Seamen, with their inherent sense of order, service, and discipline, should
really be running the world.

The numbers are importing as numbers and there is not a ' before the imported
number. I have Excel2007 and accessed the options command hidden behind the
Office Icon and everything appears as it should.
I believe the problem to be, the imported numbers are derived from an
Excel2003 spread sheet whose figures are the results of other spread sheets
to which I have no access.
--
Seamen, with their inherent sense of order, service, and discipline, should
really be running the world.


"tim m" wrote:

I would guess that the numbers are importing in as text (when you put the
cursor in the cell is there a ' before the number?)
The easiest way to correct this is to go 'tools'...'options'...'error
checking' and make sure 'number stored as text' box is checked off.

then go 'tools'...'error checking' and it will allow you to convert the
text numbers into regular numbers and thus do calculations.





"buzz" wrote:

I have EXCEL 2007 and want to import figures from a 2003 EXCEL spread sheet
whose figures are the result of other spread sheets of which I have no access.
My spread sheet does not "see" the imported figures even though I can see
them. (When I use my excel auto sum feature on the imported data, the
resultant column totals are zero.) Presently I am having to reenter the
imported data by hand into my spread sheet.
Is there a way to convert the imported figures to a form my excel can "see"
and enable me to manipulate the imported data?
buzz
--
Seamen, with their inherent sense of order, service, and discipline, should
really be running the world.