4 displays 0.04 etc

  • Thread starter Thread starter Adam
  • Start date Start date
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.
 
Hi Adam!

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

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)

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
 
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
(e-mail address removed)

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...
 
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
(e-mail address removed)

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
 
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
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
 
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
(e-mail address removed)

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
 
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
(e-mail address removed)

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
 
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
(e-mail address removed)

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
 
Hi RD!

Been there, done that!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)

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
 
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
 
Back
Top