4 displays 0.04 etc

A

Adam

Everytime I input a number it is divided by 100 so 100 is displayed as 1 and
1 as 0.01. It is happening with new and old files. I have tried the format
cells but always recognises as /100

Any ideas greatly appreciated.
 
N

Norman Harker

Hi Adam!

Use:
Tools > Options > Edit
Remove check from "Fixed decimal"
OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]

It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
exploits one of the vulnerabilities addressed by these patches is VERY
HIGH
 
A

Adam

Thanks. I feel really dumb now!
Norman Harker said:
Hi Adam!

Use:
Tools > Options > Edit
Remove check from "Fixed decimal"
OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]

It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
exploits one of the vulnerabilities addressed by these patches is VERY
HIGH
Click to expand...
 
N

Norman Harker

Hi Adam!

Been there, done that! But even dumber would be not to ask (although
Google Searching would find the answer as well- try Ron de Bruin's
free Google search addin for Excel obtained with User Guide from
http://www.rondebruin.nl/Google.htm You could use this question as a
test to see how good it is).

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]

It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
exploits one of the vulnerabilities addressed by these patches is VERY
HIGH
 
A

Anne Troy

Tools-Options, Edit tab. Uncheck Fixed Decimal.
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
 
R

RagDyeR

Hey Norman,

Any idea on how/why I *lost* the option in the <Tools> menu?

It *still* is *listed* and *checked* as an option in the Add-Ins window.

Just noticed it this A.M.

Haven't used it for a couple of days.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

Hi Adam!

Been there, done that! But even dumber would be not to ask (although
Google Searching would find the answer as well- try Ron de Bruin's
free Google search addin for Excel obtained with User Guide from
http://www.rondebruin.nl/Google.htm You could use this question as a
test to see how good it is).

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]

It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
exploits one of the vulnerabilities addressed by these patches is VERY
HIGH
 
N

Norman Harker

Hi RD!

If you're referring to Ron's Addin, it's under the Help menu.

It's his SendMail that Ron puts under the Tools menu.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]

It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
exploits one of the vulnerabilities addressed by these patches is VERY
HIGH
 
R

RagDyeR

You know, it's tough when you get so old that you walk into a room and
forget what you're doing there, and then you sit at the keyboard, and forget
what you did yesterday, that you had done for a whole year before.

Thanks Norman

Hi RD!

If you're referring to Ron's Addin, it's under the Help menu.

It's his SendMail that Ron puts under the Tools menu.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]

It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
exploits one of the vulnerabilities addressed by these patches is VERY
HIGH
 
N

Norman Harker

Hi RD!

Been there, done that!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]

It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
exploits one of the vulnerabilities addressed by these patches is VERY
HIGH
 
C

CLR

It gets worse..............I get out in the middle of a room and can't
remember if I'm on my way to the RR or on my way back from it...........and
I don't dare take the chance.......<G>

Vaya con Dios,
Chuck, CABGx3
 
Top