Kitz ADSL Broadband Information
adsl spacer  
Support this site
Home Broadband ISPs Tech Routers Wiki Forum
 
     
   Compare ISP   Rate your ISP
   Glossary   Glossary
 
Please login or register.

Login with username, password and session length
Advanced search  

News:

Author Topic: Excel problem  (Read 4457 times)

oldfogy

  • Helpful
  • Kitizen
  • *
  • Posts: 3568
  • If it ain't broke....... I'll soon fix it.
Excel problem
« on: July 18, 2007, 11:55:26 PM »

Excel problem ... With Windows XP Home.

I have 3 PCs with Office 2000 loaded on all.  :police:
Two are working okay, whilst the other is giving me problems.

PC 1&2. If I type the number 1  2  or 3 etc, it shows correctly in the cell as 1  2  or 3 or whatever I type.

PC 3. If I type the number 1  2  or 3 etc, it shows in the cell as 0.01  0.02  or 0.03 which is not what I typed and therefore does not compute in the formula (simple column addition).

The only way to get it to add-up correctly is to add a decimal point after each number is typed, such as 1.  2.  3. etc
No matter how the cells are formatted, whether as "Number, Currency" or even general the problem still occurs.
And it's a pain having to do this all the time.

Any suggestions how to correct this problem please.
Logged

Achilles Last Stand

  • Kitizen
  • ****
  • Posts: 3554
  • http://www.saveplanetrock.co.uk/ Save Planet Rock!
Re: Excel problem
« Reply #1 on: July 19, 2007, 10:24:28 AM »

Well, I'm baffled OF  :no:  I've had a good rummage and can't see any other way of changing the number format other that Format/Cells.  Even the Style option just takes you back to the Cells box.

I'll think on it a while.


Edit - have you tried clearing the cells of formatting (rather than just trying to change it):

« Last Edit: July 19, 2007, 10:50:46 AM by Achilles Last Stand »
Logged

kitz

  • Administrator
  • Senior Kitizen
  • *
  • Posts: 31977
  • Trinity: Most guys do.
    • http://www.kitz.co.uk
Re: Excel problem
« Reply #2 on: July 19, 2007, 10:51:14 AM »

Without looking too deep its possibly a custom format thats been applied to a doc and then saved to the excel template by mistake.
Something like #,###.#0

You could try recreating a new template
- or alternatively it may be easier to take a copy of the templates from one of the other machines and putting that on the machine thats causing the problem.

Theres some info here how to change the default template
http://www.vlerick.be/helpdesk/our_services/faq/software_solution/microsoft/excel/faq_default_template.html
Logged
Please do not PM me with queries for broadband help as I may not be able to respond.
-----
How to get your router line stats :: ADSL Exchange Checker

John McG

  • Member
  • **
  • Posts: 51
  • Be Happy!
Re: Excel problem
« Reply #3 on: July 19, 2007, 12:41:33 PM »

Hi OF,

Try this - it seems to explain your symptoms!

http://www.excelforum.com/showthread.php?t=607555

JM  8)
Logged
Genius may have its limitations, but stupidity is not thus handicapped!

Pwiggler

  • Kitizen
  • ****
  • Posts: 1542
Re: Excel problem
« Reply #4 on: July 19, 2007, 12:50:52 PM »

hi OF

u could try START > RUN  then type the path to the office folder, then excel.exe /regserver

this'll reset the registry for excel.  then copy sheet.xlt from a working machine to the effected machine.

Logged
Paul

oldfogy

  • Helpful
  • Kitizen
  • *
  • Posts: 3568
  • If it ain't broke....... I'll soon fix it.
Re: Excel problem
« Reply #5 on: July 19, 2007, 01:57:47 PM »

Hi OF,

Try this - it seems to explain your symptoms!

http://www.excelforum.com/showthread.php?t=607555
JM  8)
Thanks people (everyone that is) especially JM

The solution has now been found and so simple, after racking my grey matter and nearly getting to the reinstall stage, not that I thought that would cure the problem (don't know why, just did).

Quote
Try

Tools > options > Edit Tab > Fixed Decimal is unticked

VBA Noob
Thanks also to VBA Noob for the solution, should he/she ever wonder in here.
Logged

John McG

  • Member
  • **
  • Posts: 51
  • Be Happy!
Re: Excel problem
« Reply #6 on: July 19, 2007, 02:52:18 PM »

Thanks also to VBA Noob for the solution, should he/she ever wonder in here.

... I ofter wonder in here ......  ;D
Logged
Genius may have its limitations, but stupidity is not thus handicapped!

kitz

  • Administrator
  • Senior Kitizen
  • *
  • Posts: 31977
  • Trinity: Most guys do.
    • http://www.kitz.co.uk
Re: Excel problem
« Reply #7 on: July 19, 2007, 10:42:30 PM »

 :D
Logged
Please do not PM me with queries for broadband help as I may not be able to respond.
-----
How to get your router line stats :: ADSL Exchange Checker

oldfogy

  • Helpful
  • Kitizen
  • *
  • Posts: 3568
  • If it ain't broke....... I'll soon fix it.
Re: Excel problem
« Reply #8 on: July 20, 2007, 09:46:18 PM »

>> ... I ofter wonder in here ......   :D

Okay so my spell checker does not know the difference with "Wonder" & "Wander"  :P

********************************

Kitz,
Are notifications switched off ?
Only I did not receive one for either of the last two replies to this thread, only noticed further comments by accident.
Logged

kitz

  • Administrator
  • Senior Kitizen
  • *
  • Posts: 31977
  • Trinity: Most guys do.
    • http://www.kitz.co.uk
Re: Excel problem
« Reply #9 on: July 20, 2007, 10:06:57 PM »

nope theyre switched on.

Seem to be getting them ok here.... anyone else having problems?
Logged
Please do not PM me with queries for broadband help as I may not be able to respond.
-----
How to get your router line stats :: ADSL Exchange Checker

oldfogy

  • Helpful
  • Kitizen
  • *
  • Posts: 3568
  • If it ain't broke....... I'll soon fix it.
Re: Excel problem
« Reply #10 on: July 20, 2007, 10:10:05 PM »

Received okay, i'll put it down to a blip or two (two threads).

Thanks for looking.
Logged

kitz

  • Administrator
  • Senior Kitizen
  • *
  • Posts: 31977
  • Trinity: Most guys do.
    • http://www.kitz.co.uk
Re: Excel problem
« Reply #11 on: July 20, 2007, 10:17:49 PM »

okies ty phil.

Just check that any havent accidentally gone into a spam folder.

Btw youre not with aol are you?
Logged
Please do not PM me with queries for broadband help as I may not be able to respond.
-----
How to get your router line stats :: ADSL Exchange Checker

oldfogy

  • Helpful
  • Kitizen
  • *
  • Posts: 3568
  • If it ain't broke....... I'll soon fix it.
Re: Excel problem
« Reply #12 on: July 20, 2007, 10:26:57 PM »

.. Btw you're not with AOL are you?

No, Virgin (ISP that is)  :angel:

The spam folder is clear also.
********************************

Just another thanks whilst I'm here. I tried for ages the other day to try and find "AVG free version", eventually I  gave up.
Then decided to look on your main site and found the link to it straight-away, so thanks again.
Logged

kitz

  • Administrator
  • Senior Kitizen
  • *
  • Posts: 31977
  • Trinity: Most guys do.
    • http://www.kitz.co.uk
Re: Excel problem
« Reply #13 on: July 21, 2007, 12:27:04 AM »

yw

Re AOL - The only reason I ask is that I was looking the other day at the number of users that had signed up to these forums but not actually activated their accounts and there appeared to be a large proportion of aol users.
I'm aware that aol can often be ardent with their spam filtering and wondered if perhaps aol was being a bit over-zealous. 
The address from which the forum mail for any notifications or signup messages isnt monitored, therefore any bounced or any replies to that address wouldnt be noticed by me.
Logged
Please do not PM me with queries for broadband help as I may not be able to respond.
-----
How to get your router line stats :: ADSL Exchange Checker