excel
When I open a new spreadsheet and enter any number it is divided by 100. No
formulae are present, when I open an old sheet and enter a number in a blank field it is also divided. Any ideas ( new to excel) |
Hi,
It could be that you are set on 'Fixed Decimal' Goto menu Tools Options, tab Edit, uncheck 'Fixed Decimal' -- Regards, Sébastien "Tam W" wrote: When I open a new spreadsheet and enter any number it is divided by 100. No formulae are present, when I open an old sheet and enter a number in a blank field it is also divided. Any ideas ( new to excel) |
All times are GMT +1. The time now is 07:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com