#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Obviously you have somehow selected this option! Uncheck it!
|
#3
|
|||
|
|||
thank you ArviLaanemets, although my options are different from yours I have unticked add decimal pointsand that has sorted it, I appreciate yor help and advice
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Problem with page number header | webgal318 | Word | 4 | 06-22-2020 06:40 PM |
Number List Problem! | Mole Patrol | Word | 2 | 09-18-2013 11:46 AM |
Page Number problem | lugibson | Word | 3 | 08-12-2011 03:45 AM |
Problem with of Number of pages | ilkks | Word | 3 | 05-25-2011 02:27 PM |
Number of lines on page problem | JamesT | Word | 0 | 08-27-2009 04:52 PM |