Kitz Forum

Computer Software => General software => Topic started by: oldfogy on July 18, 2007, 11:55:26 PM

Title: Excel problem
Post by: oldfogy 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.
Title: Re: Excel problem
Post by: Achilles Last Stand 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):

(https://forum.kitz.co.uk/proxy.php?request=http%3A%2F%2Fi102.photobucket.com%2Falbums%2Fm87%2Fpassionplay65%2FFor%2520others%2Fexcelclearformatting.gif&hash=3d0a73b99f3930a3bc113daabe814408)
Title: Re: Excel problem
Post by: kitz 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
Title: Re: Excel problem
Post by: John McG 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)
Title: Re: Excel problem
Post by: Pwiggler 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.

Title: Re: Excel problem
Post by: oldfogy 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.
Title: Re: Excel problem
Post by: John McG 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
Title: Re: Excel problem
Post by: kitz on July 19, 2007, 10:42:30 PM
 :D
Title: Re: Excel problem
Post by: oldfogy 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.
Title: Re: Excel problem
Post by: kitz on July 20, 2007, 10:06:57 PM
nope theyre switched on.

Seem to be getting them ok here.... anyone else having problems?
Title: Re: Excel problem
Post by: oldfogy 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.
Title: Re: Excel problem
Post by: kitz 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?
Title: Re: Excel problem
Post by: oldfogy 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.
Title: Re: Excel problem
Post by: kitz 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.