Hi Team.
You have never let me down as I can always rely on this team for answers. I have thousands of records where the number has varying decimal lengths ranging from 1 to 4 decimal places (e.g. 3000123.1 to 3000546.4444). The decimals are versions so ".1" is different than ".1000". I need to keep the versions intact. Excel is converting to scientific notation and simply changing the data to a number format with 4 decimals places will not work as it changes the data. Does anyone have any ideas how I can convert the scientific notation without jeopardizing the integrity of the data? Thx team.
You have never let me down as I can always rely on this team for answers. I have thousands of records where the number has varying decimal lengths ranging from 1 to 4 decimal places (e.g. 3000123.1 to 3000546.4444). The decimals are versions so ".1" is different than ".1000". I need to keep the versions intact. Excel is converting to scientific notation and simply changing the data to a number format with 4 decimals places will not work as it changes the data. Does anyone have any ideas how I can convert the scientific notation without jeopardizing the integrity of the data? Thx team.