Problems with formating and formulas in Excel 2002

[Excel 2002 - Problems with Formulas]

I am having problems with the sum formula in Excel 2002.
I take a straight copy of data in an acess database (not
an export) and paste it into an excel spreadsheet.

I can not seem to format the cells nor can I use the Sum
formula to calculate. If I manually re-type all the
numeric value these problems seem to disappear.

The problems seem to have started when Access XP was
installed onto the PC but niether removing Access no re-
installing the PC has worked to correct this problem.

Has anyone else seen something similar?

 

[Andy B]

Hi

It sounds to me like the cells are coming in as text, rather than numbers.

Copy an unused cell (not formatted as text). Select your 'numbers' and then
Paste/Special/Add.

Andy.

 

[Guest]

Andy

I am having the same problem, however I am still unable to fromat the text

----- Andy B wrote: ----

H

It sounds to me like the cells are coming in as text, rather than numbers

Copy an unused cell (not formatted as text). Select your 'numbers' and the
Paste/Special/Add

Andy

"Excel 2002 - Problems with Formulas" <[email protected]
wrote in message news:[email protected]..

 

[Dave Peterson]

Are you pasting from Access--or the web?

Sometimes there's stuff that looks like spaces in the cell that cause the
numbers to be treated as text. (Sometimes, it's really spaces. Sometimes, it's
HTML's non-breaking space.)

If this sounds like it might be the case, the you may want to try David
McRitchie's TrimAll macro.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall
(look for "Sub Trimall()")

David also has instructions on how to install a macro and run it at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm