LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Unwanted decimal places when entering integers

Forgive me if this is not the correct group for this problem; if it
isn't please tell me where to go.

I have been using a particular spreadsheet for 3-4 years and was able to
enter integers into a column of cells, and having formatted the cells as
numbers having no decimal place have them show as integers and behave as
integers in formulae.

Some weeks ago for reasons entirely unknown to me Excel insists on
dividing the numbers by 100 so that e.g. 1 becomes 0.01; it shows as 0
if I format the cell as an integer but acts like a 0.01 in formulae.
Excel also does this in new spreadsheets.

I have noticed some weird things about this problem, in particular that
the same spreadsheet run on another computer behaves the way it was
originally designed to - i.e, when I enter 1 I get 1. The problem is
not present when I run Excel in safe mode or when I run Windows XP in
safe mode, but it is very inconvenient to run Excel in safe mode and I
shouldn't have to anyway. I have checked for add-ons for Excel but they
there don't seem to be any.

I don't get the problem when I run the spreadsheet under OpenOffice Calc
as an Excel program, but I'd like to be able to run it under Excel.

Can anyone help please or point me to a document in the Microsoft labyrinth?

--
Regards, Alex
 
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
How many decimal places can a cell display? Spaz Excel Worksheet Functions 10 April 3rd 06 08:33 PM
Formula for: Format Decimal places? nastech Excel Discussion (Misc queries) 16 November 4th 05 02:25 PM
Excel adds phantom decimal places: why? Dave O Excel Discussion (Misc queries) 1 August 16th 05 06:25 PM
Excel defaulting to 3 decimal places when using the gen. format cprtrain Excel Discussion (Misc queries) 1 July 31st 05 04:29 AM
Entering numbers with variable decimal places. Jack Excel Worksheet Functions 8 February 2nd 05 04:35 AM


All times are GMT +1. The time now is 11:57 PM.

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

About Us

"It's about Microsoft Excel"