Can't get general number format to work. 2

[RBP]

Anyone help with this?
I'm using Vista Business, and office 2007, I upgraded to SP1 the other day, bad move I suspect.
When I key in a number into an excel cell - say "123456" the formatting is General, when I move off the cell, excel kindly divides the number by 100 i.e. 12.345. DAMMIT I don't want it to I never told it to!

It never did this before from what I can remember.
I can set the cell to TEXT, but it left justifies by default, not what I want.

Can anyone tell me why I just can't type in a number less than 15 digits and expect to see a simple string of numbers?
Previous versions of Excel on other pc's don't mess me about like this.

 

[GlennUK]

Firstly, your example of what is happening is a bit mangled ... 123456 divided by a hundred is not 12.345 so is the entry dividing by a hundred, or a thousand, or 10000?

Secondly, let's assume that it's dividing by 100, look at Tools/Options/Edit and see if the Fixed Decimal Places checkbox is ticked. If it is, untick it.


Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[SkipVought]

Hi,

2007 - Office Button > Excel Options > Advanced - Automatically insert a decimal point...

Is it checked?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[GlennUK]

D'oh, Office 2007 ... the OP said it, I've got it, but I went and gave the Excel 2003 answer anyway.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[RBP]

Sorry Glenn, I'm old enough to remember when A levels didn't come in a lucky bag, and hence sums are not my strongest point.
Here goes,
enter 1234, displays 12.34
enter 12345, displays 123.45
enter 123456, displays 1234.56 sorry for the poor previous description.
Excel 2007 does not have the same path to Tools>Options as it used to, but with the trusty old stick I managed to beat an answer out of it.
windows own quote helpfile.
"What happened to the Options command on the Tools menu?"

Under Excel options / advanced, there is a check box for Automatically inserting a decimal place.
Hand on heart I NEVER touched this - honest! unchecking it abates my frustrations.
Thanks for the time and your pointer.
Regards Rob.

 

[SkipVought]

Ha! I had to put down my laptop w/ 2003 and open the 2007 on the desktop. I am YET, groping around in there!!!

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[RBP]

All cured and working thanks to all.
Rob.

 

[GlennUK]

Glad to have been of some help ... I wouldn't have known Skip's answer without some digging and groping around ... yes Skip, am still groping around with the interface on Excel 2007.

( do you type part of an Excel 2003 menu command, and Excel 2007 starts to understand it, then because Excel 2007 prompting of "Office 2003 access key - continue typing etc" has distracted you, you can't remember what the rest of the key sequence is??? that's annoying )

Cheers, Glenn.

Beauty is in the eye of the beerholder.