XL XP number problem
using office XP on an old laptop running windows 10, laptop is not connected to the internet so no problem with it being hacked, prefer the toolbar on XP, customised the way I want it, been using it since XP came out
using XL, every time I enter a number in a cell it has started showing the number as a decimal number, ie enter number 6 I get 0.06, I have tried various cell formatting options, if I change the cell formatting to zero decimal points the numbers change to 0 no matter what number I enter, I have attached a sample file to give options, does anybody have any ideas of what has changed and how I can sort it
|