excel problem, need help.........

[Brinxmat]

Thanks for having a look at it anyway!

RIGHT!!!

Don't understand this but I think I have a FIX if nothing else.

*Before doing any of this I would make a copy of the original - I make no guarantees, I offer no refunds

Double-click on a cell with the number "1" in it - it has to be a "1".

Click on Copy on the toolbar.

Then highlight all of the cells you want to make SUMmable.

From the Toolbar, choose Edit...PASTE SPECIAL...and choose MULTIPLY (listed in the OPERATION section).


What this does is take a perfectly well formatted "1" and whenever it sees a number, whether it is formatted as a number or not, it multiplies it by 1 and then your totals work...

Ta-da!

 

[Leafster]

Nice one!

 

[Brinxmat]

Nice one!

Quod Erat Demonstrandum...

...and it was only a matter of time before the you that is me thought the same thing and posted it for the me that is you to slam the desk in admiration of the simplicity of it all.

*maybe I overdid the coffee a tad, there.

 

[internetstalker]

RIGHT!!!

Don't understand this but I think I have a FIX if nothing else.

*Before doing any of this I would make a copy of the original - I make no guarantees, I offer no refunds

Double-click on a cell with the number "1" in it - it has to be a "1".

Click on Copy on the toolbar.

Then highlight all of the cells you want to make SUMmable.

From the Toolbar, choose Edit...PASTE SPECIAL...and choose MULTIPLY (listed in the OPERATION section).


What this does is take a perfectly well formatted "1" and whenever it sees a number, whether it is formatted as a number or not, it multiplies it by 1 and then your totals work...

Ta-da!

He shoots!

He Scores!












YES!!

You are a winner

thankyou

 

[Brinxmat]

YES!!

You are a winner

thankyou

...Please.

It's just nice to have been asked.

I'd like to thank...

 

[MooChild]

Hey well done mate

Another way is to add another column (b) and do =a1*1 in cell b1 etc. Brinx did the same thing but with paste special.

Its excel not recognising the numbers as numbers. tis a pain

 

[Brinxmat]

Hey well done mate

Another way is to add another column (b) and do =a1*1 in cell b1 etc. Brinx did the same thing but with paste special.

Its excel not recognising the numbers as numbers. tis a pain

Who said the office would fall apart without your skills?

*turns to see everyone with their hand up.

Alright, but I'm chuffed I got this one...

 

[MooChild]

Who said the office would fall apart without your skills?

*turns to see everyone with their hand up.

Alright, but I'm chuffed I got this one...

Yar, me too. bout time you got some mad excel skillz

lol, i just read that back and realised how sad it sounds. oh well, it pays the bills

 

[London_Calling]

Okay,
I've come across some Visual Basic code inside the attachment that clears out excessive formatting, but no macros listed under Tools?
Do you run any macros within this spreadsheet?

My VBA skills are on a par with my Latin, sadly.

You're right, it's a vba issue.


God knows what that work around does