|
| 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
March 30th, 2005, 09:37 AM
|
|||
|
|||
number formats default to 2 decimal points when entered so 24 bec.
number formats default to 2 decimal points when entered so 24 becomes 0.24.
A number setting would seem to be the problem but I cannot find anything that can change it at present 
|
|
#2
March 30th, 2005, 09:48 AM
|
|||
|
|||
|
ToolsOptionsEdit, uncheck Fixed decimal
-- Kind Regards, Niek Otten Microsoft MVP - Excel "kiddo7us" wrote in message ... number formats default to 2 decimal points when entered so 24 becomes 0.24. A number setting would seem to be the problem but I cannot find anything that can change it at present
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Maximum Number of Cell Formats | Jim Allen | General Discussion | 4 | April 19th, 2005 07:07 PM |
| Excel divides number by 10e6 unless followed by decimal point. | JohnO | General Discussion | 5 | March 22nd, 2005 02:07 AM |
| Converting Hexadecimal number to floating point decimal number | Fifi | General Discussion | 2 | October 27th, 2004 05:04 PM |
| Why do the general and number cell formats not work correctly? | Frank Schiermeier | Worksheet Functions | 1 | October 5th, 2004 08:12 PM |
| Custom Number Formats and system | Josh O. | Worksheet Functions | 3 | August 27th, 2004 01:49 AM |
Linear Mode
