![]() |
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. |
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. |
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