Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Troubleshoot a bug in Excel
I am just begining to use Excel spreadsheets after using Lotus 1-2-3
spreadsheets for several years. Whenever I enter a number in a cell. Excel adds a decimal point, even if the number format I use doesn't include a decimal point. It just doesn't look right to have an interger number like 5280 displayed as 5280.(with decimal point) Is this a bug in Excel? How can I fix this problem? |
#2
|
|||
|
|||
Troubleshoot a bug in Excel
On 16 Oct 2005 18:28:09 -0700, "
wrote: I am just begining to use Excel spreadsheets after using Lotus 1-2-3 spreadsheets for several years. Whenever I enter a number in a cell. Excel adds a decimal point, even if the number format I use doesn't include a decimal point. It just doesn't look right to have an interger number like 5280 displayed as 5280.(with decimal point) Is this a bug in Excel? How can I fix this problem? Hmm, I can't reproduce this problem in XL2002 under Windows XP Pro. Even if I type in 23.0, with Number Format and 0 decimal places (or General format), I do not see a decimal point displayed. (Unless I enter it as TEXT). What version? What, exactly, is the cell format? Did you set it before or after you entered the number? What are your regional/language options (under Control Panel). I'm looking for clues; but maybe someone else has run across this before. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening two separate instances of Excel | Excel Discussion (Misc queries) | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel |