ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   numeric entries modified (https://www.excelbanter.com/excel-discussion-misc-queries/85887-numeric-entries-modified.html)

dodhner

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.


Toppers

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.


Peo Sjoblom

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.





All times are GMT +1. The time now is 01:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com