|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 31st, 2004, 05:50 AM
|
|||
|
|||
Decimal Point Added to end of number bug
HI
I am just beginning to use Excel spreadsheets. My problem is whenever I enter a number into a cell, Excel automatically adds a decimal point to the end of the number - ie if I enter 1234 - the number is displayed as 1234. Could anybody tell me if this is an Excel bug? Or if anybody could provide a solution, I would be grateful. Cheers jdyer  --- Message posted from http://www.ExcelForum.com/ 
|
|
#2
August 31st, 2004, 07:16 AM
|
|||
|
|||
|
Hi
you may check the format of this cell as well as 'Tools - Options - Edit' and make sure 'Fixed decimals' is not checked -- Regards Frank Kabel Frankfurt, Germany "jdyer " schrieb im Newsbeitrag ... HI I am just beginning to use Excel spreadsheets. My problem is whenever I enter a number into a cell, Excel automatically adds a decimal point to the end of the number - ie if I enter 1234 - the number is displayed as 1234. Could anybody tell me if this is an Excel bug? Or if anybody could provide a solution, I would be grateful. Cheers jdyer --- Message posted from http://www.ExcelForum.com/
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Format problem : "Text" & Number; Number -> Standard format. How? | BerHav | Setting Up & Running Reports | 0 | August 19th, 2004 06:31 PM |
| Time to Decimal point | Steved | Worksheet Functions | 2 | March 29th, 2004 07:53 AM |
| Decimal Point Separator | Mark | Setting up and Configuration | 1 | March 19th, 2004 06:16 PM |
| Rounding Functions | Teacher | Worksheet Functions | 2 | January 7th, 2004 02:27 PM |
Linear Mode
