Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-15-2017, 11:05 PM
keggieman keggieman is offline Strange numbers coming up Windows 7 64bit Strange numbers coming up Office 2010 64bit
Novice
Strange numbers coming up
 
Join Date: Apr 2015
Posts: 11
keggieman is on a distinguished road
Default Strange numbers coming up

Whern I try to input a number in Excel start 2010 it has suddenly started putting whole numbers after decimal point



I have tried every option but I cannot get out of this situation

It had been working precviously
Reply With Quote
  #2  
Old 01-16-2017, 01:07 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Strange numbers coming up Windows 7 64bit Strange numbers coming up Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Could you show some examples please?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 01-16-2017, 06:56 AM
keggieman keggieman is offline Strange numbers coming up Windows 7 64bit Strange numbers coming up Office 2010 64bit
Novice
Strange numbers coming up
 
Join Date: Apr 2015
Posts: 11
keggieman is on a distinguished road
Default

I input 4, with option "Greneral" it commes up as 0.04
I tell it 2 decimal places, it comes up again at 0.04
I tell it no decimal places, it comes up as 0

Any suggestions?

Keggie
Reply With Quote
  #4  
Old 01-16-2017, 07:12 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Strange numbers coming up Windows 7 64bit Strange numbers coming up Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

I haven't got XL here. Perhaps check the Options to see of something is abnormal
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #5  
Old 01-16-2017, 07:37 AM
xor xor is offline Strange numbers coming up Windows 10 Strange numbers coming up Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

You should do as Pecoflyer suggests.

Click File (on the Ribbon) then Options then Advanced. Remove tick mark at Automatically insert a decimal point.
Reply With Quote
  #6  
Old 01-16-2017, 09:23 AM
keggieman keggieman is offline Strange numbers coming up Windows 7 64bit Strange numbers coming up Office 2010 64bit
Novice
Strange numbers coming up
 
Join Date: Apr 2015
Posts: 11
keggieman is on a distinguished road
Default

Fantastic, many thanks
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail not coming through. Jeff Fenerty Outlook 0 01-01-2016 07:16 PM
Outline numbering: 2.1 coming out as 1.1 Remster Word 3 12-07-2011 12:16 PM
Strange numbers coming up See next coming slide Dig PowerPoint 1 05-27-2011 04:53 PM
PP Keeps coming up with corrupted files. RM@N PowerPoint 1 04-18-2011 03:45 PM
David.ttf font coming up bold nazareneisrael Word 0 01-25-2010 11:07 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:14 AM.


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