Kitz Forum
Computer Software => General software => Topic started 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.
-
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=3911c92e6923922dd739c98c5007e80c29f58bde)
-
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
-
Hi OF,
Try this - it seems to explain your symptoms!
http://www.excelforum.com/showthread.php?t=607555
JM 8)
-
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.
-
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).
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.
-
Thanks also to VBA Noob for the solution, should he/she ever wonder in here.
... I ofter wonder in here ...... ;D
-
:D
-
>> ... 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.
-
nope theyre switched on.
Seem to be getting them ok here.... anyone else having problems?
-
Received okay, i'll put it down to a blip or two (two threads).
Thanks for looking.
-
okies ty phil.
Just check that any havent accidentally gone into a spam folder.
Btw youre not with aol are you?
-
.. 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.
-
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.