Cell Formatting
 

Seem to have created a monster. When I type 122 in a cell it displays as 1.22
Any numeric I type ends up with decimal point moved two places to the left
and I can't seem to correct. Is there some obvious formatting that I am
missing?

Cell Formatting
 

On the Tools menu, choose Options then the Edit tab. There, uncheck the
"Fixed Decimal" setting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Steve" wrote in message
...
Seem to have created a monster. When I type 122 in a cell it displays as
1.22
Any numeric I type ends up with decimal point moved two places to the left
and I can't seem to correct. Is there some obvious formatting that I am
missing?

Cell Formatting
 

Tools Options Edit Uncheck "Fixed decimal"

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Steve" wrote in message
...
Seem to have created a monster. When I type 122 in a cell it displays as
1.22
Any numeric I type ends up with decimal point moved two places to the left
and I can't seem to correct. Is there some obvious formatting that I am
missing?

Cell Formatting
 

Use Tools | Options; open the Edit tab and deselect the "Fixed decimal" box
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Steve" wrote in message
...
Seem to have created a monster. When I type 122 in a cell it displays as
1.22
Any numeric I type ends up with decimal point moved two places to the left
and I can't seem to correct. Is there some obvious formatting that I am
missing?

Cell Formatting
 

Thanks, I've been looking everywhere and guess I missed this one. Again
thanks and Best

"Bernard Liengme" wrote:

Use Tools | Options; open the Edit tab and deselect the "Fixed decimal" box
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Steve" wrote in message
...
Seem to have created a monster. When I type 122 in a cell it displays as
1.22
Any numeric I type ends up with decimal point moved two places to the left
and I can't seem to correct. Is there some obvious formatting that I am
missing?

Cell Formatting
 

Not formatting, I would suspect.

Tools/ Options/ Edit:
Unselect "Fixed decimal places".
--
David Biddulph

"Steve" wrote in message
...
Seem to have created a monster. When I type 122 in a cell it displays as
1.22
Any numeric I type ends up with decimal point moved two places to the left
and I can't seem to correct. Is there some obvious formatting that I am
missing?