ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Default (https://www.excelbanter.com/setting-up-configuration-excel/27107-default.html)

Falaise

Default
 
Enter a numberin cell eg 56. It automatically becomes 0.56


Bob Phillips

ToolsOptionsEdit and uncheck the Fixed Decimal box.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Falaise" wrote in message
...
Enter a numberin cell eg 56. It automatically becomes 0.56





All times are GMT +1. The time now is 06:04 PM.

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