Same cell formatting gives different data presentation?

[jb]

Hi all experts,
I have applied normdist function of excel in my workbook.
Calculation formula is same for some number of rows.
But the first row shows value in E format while others show decimal values.
I applied format painter also. But it is not working.
Help me to get all values in decimal format.


8.40971E-05
0.000811025
0.004817467
0.017625244
0.03971763
0.055126859
0.047127556
0.024815232
0.008048103
0.001607683
0.000197806

 

[bobhc]

Good day jb this link will explain all

http://peltiertech.com/Excel/NumberFormats.html


.