Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Incorrect number entry on Excel for Mac 2011

Hi,
Recently, I find that when I open a workbook and type into any cell, a number, say 123, and press enter then the cell shows 0.123. Somehow, every number is divided by a thousand. The General format shows 0.123 as does the Number format. This occurs with all workbooks. Can anyone tell me what is happening?
Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Incorrect number entry on Excel for Mac 2011

It sounds like you have a fix to three decimal place in your settings. Remove that and that should take care of your problem. When you enter three numbers it thinks it's the three decimals and calculates it that way. This is going off the top of my head and hope it works
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Incorrect number entry on Excel for Mac 2011

On Friday, April 28, 2017 at 4:42:49 PM UTC+1, kenrock wrote:
Hi,
Recently, I find that when I open a workbook and type into any cell, a number, say 123, and press enter then the cell shows 0.123. Somehow, every number is divided by a thousand. The General format shows 0.123 as does the Number format. This occurs with all workbooks. Can anyone tell me what is happening?
Thanks.


Many thanks for your response. Yes, a box had been ticked in the Preferences - Edit section. Sanity now reigns!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel 2011 won't sort alphabetically walkingfern New Users to Excel 9 September 28th 14 07:48 PM
Dir function on Excel 2011 for Mac watergate74[_2_] Excel Programming 1 November 3rd 12 04:13 PM
Excel 2011 for Mac tries to run a file when it starts up Drew[_12_] Excel Programming 0 August 21st 11 11:54 AM
LoadPicture command for excel 2011 for Mac Andrew Bourke Excel Programming 0 May 26th 11 12:00 AM
Incorrect row number in my excel spread sheet hsvgal Excel Discussion (Misc queries) 1 July 30th 08 02:18 AM


All times are GMT +1. The time now is 06:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"