| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
largest value that can be entered into MS Excel field
If I type in the following number into a field:
123,456,789,123,456,789 and hit enter, I get the following number in the field: 123,456,789,123,456,000 If I then take the second number, subtract 2 from it in another cell, and then do an exact function on the 2nd and 3rd (now 2 less than the 2nd), I get a "TRUE" result. I'm using Excel 2003, service pack 2. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function to find 'n'th largest alphanumeric field (like "Large") | Excel Worksheet Functions | |||
| LArgest spreadsheet under Excel - Rows | Excel Discussion (Misc queries) | |||
| How to check for and replace the largest number in excel | Excel Worksheet Functions | |||
| How do I set up excel to tab from field to field in a form? | Excel Discussion (Misc queries) | |||
| How to Join/concatenate a date field with a time field in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
