| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with concatination result. Last digit change to 0
Here are the steps I am performing
I am concatinating 2 numeric fields. Copy Paste Special Values - This then makes the result text A warning box comes up and I click on it and specify to convert to number When it converts the result, it formats it to Scientific notation I then format it to Number with zero decimals This then changes the last digit to 0. 910000026 1370735 is what I begin with 9100000261370730 is what I end up with |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change first 2 digit ignore the other 2. | Excel Worksheet Functions | |||
| How set a format on one of more strings in a concatination | Excel Discussion (Misc queries) | |||
| Change second digit from 4 to 6 | Excel Worksheet Functions | |||
| 16th digit changes?? Problem,16th digit changes to a zero.... | Excel Worksheet Functions | |||
| Excal Concatination of cells that are not empty | Excel Worksheet Functions | |||
Threaded Mode
