Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
numeric entries modified
In a particular column, numberic entries are automatically divided by 100.
At my last use of this spreadsheet, I didn't have this problem. I may have inadvertantly pressed some keys which initiated this. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
numeric entries modified
Check Tools==Options=Edit==Fixed decimal places - latter should NOT be
ticked. "dodhner" wrote: In a particular column, numberic entries are automatically divided by 100. At my last use of this spreadsheet, I didn't have this problem. I may have inadvertantly pressed some keys which initiated this. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
numeric entries modified
Toolsoptionseditdeselect fixed decimal places
You probably didn't change this, you probably opened a workbook that already had these settings -- Regards, Peo Sjoblom http://nwexcelsolutions.com "dodhner" wrote in message ... In a particular column, numberic entries are automatically divided by 100. At my last use of this spreadsheet, I didn't have this problem. I may have inadvertantly pressed some keys which initiated this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return Summed Count of Multiple Consecutive Numeric Values | Excel Worksheet Functions | |||
Match 3 Criteria and Return Lowest Numeric Value | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
How can I stop all numeric entries from being devided by 100? | Excel Discussion (Misc queries) |