Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting question (if cell = 0, wrap cell in quotes) | New Users to Excel | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
Conditional cell background formatting, based on cell content | Excel Discussion (Misc queries) |