| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
16 digit number wont keep alteration unless format cell to text
Using excel 2000
recieving data from client with 16 numeral characters within cells cells show an abreviated listing for the number (2.06E+15) When editing the the number (wanting to change the last number by 1 digit) i.e. 2059510000000000 - change to - 2059510000000001 this change will not be kept?? I format the cell to "numbers" with no decimal point as a whole number is required Any ideas?? Is this number to long for excell 2000?? I'm not a big excel user Cheers Croc001 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I format a cell for a custom part number? | Excel Discussion (Misc queries) | |||
| Telephone number format | Excel Discussion (Misc queries) | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
| How do i change numbers in text format to number format? | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
