LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
TSL1050
 
Posts: n/a
Default Excel does not display entered values correctly

I am currently running Excel 2000 on WinXP Pro. Excel does not display the
correct values in cells when they are typed. The program arbitrarily assigns
a decimal value to whatever number is typed. For example, if "1111111111" is
entered, it is displayed as "11111.11111" I have gone through cell
formatting, detect and repair and other options, but none have worked. The
program use to work fine. It started this recently and it won't go away. If
it helps, when a number is typed in another program, i.e. notepad, and copied
and pasted into Excel the value displays fine. The problem lies in actually
typing values into Excel. This is a problem that I am unfamiliar with. Any
help is greatly appreciated.

Thank you,
John

 
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
return multiple corresponding values in excel Chiller Excel Worksheet Functions 5 January 12th 06 05:43 PM
How to assign character (text) values to y-axis in a Excel chart? cy Charts and Charting in Excel 1 July 16th 05 10:39 PM
Excel Compare values in columns & display missing values in a new cpetta Excel Discussion (Misc queries) 1 April 2nd 05 05:51 AM
Missing values in Excel Line Chart mw55309 Charts and Charting in Excel 1 January 19th 05 12:10 PM
Stop Excel from converting text labels in CSV files to Values Just Want a Label! Excel Discussion (Misc queries) 1 January 11th 05 04:51 PM


All times are GMT +1. The time now is 08:13 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"