Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-22-2020, 06:28 AM
xp user xp user is offline XL XP number problem Windows 10 XL XP number problem Office 97-2003
Novice
XL XP number problem
 
Join Date: Nov 2020
Posts: 6
xp user is on a distinguished road
Default 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
Attached Files
File Type: xls Book1.xls (13.5 KB, 12 views)
Reply With Quote
  #2  
Old 11-23-2020, 12:12 AM
ArviLaanemets ArviLaanemets is offline XL XP number problem Windows 8 XL XP number problem Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Obviously you have somehow selected this option! Uncheck it!
Attached Images
File Type: jpg EcxelInsertsDecimal.JPG (146.7 KB, 12 views)
Reply With Quote
  #3  
Old 11-23-2020, 03:08 AM
xp user xp user is offline XL XP number problem Windows 10 XL XP number problem Office 97-2003
Novice
XL XP number problem
 
Join Date: Nov 2020
Posts: 6
xp user is on a distinguished road
Default

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
Attached Images
File Type: png Capture.PNG (16.0 KB, 10 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
XL XP number problem Problem with page number header webgal318 Word 4 06-22-2020 06:40 PM
XL XP number problem Number List Problem! Mole Patrol Word 2 09-18-2013 11:46 AM
XL XP number problem Page Number problem lugibson Word 3 08-12-2011 03:45 AM
XL XP number problem 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:51 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft