Excel data type

[rahe_wafa20]

Meray Pass Excel mein scientific notation mein data hay.

2.88204E15
2.91267E15
2.92247E15
2.93819E15
2.9628E15
.
.
.

Mager data ko plot kerney k liye sirf "coefficients" ko show kerwana chahta hun. Aur 10 ki power show nahi kerwana chahta. yani
2.88204
2.91267
2.92247
2.93819
2.9628
.
.
.


sirf coefficients ko lena hay 10 ki powers chor di hain. Chunka data bohut zayada hay is liye main aik aik data points ko lay ker her aik ka exponent remove nahi ker sakta. please is ka koi solution batain.

[rahe_wafa20]

woh log jo excel jantey hain pls madad karain

[syar]

Meray Pass Excel mein scientific notation mein data hay.

2.88204E15
2.91267E15
2.92247E15
2.93819E15
2.9628E15
.
.
.

Mager data ko plot kerney k liye sirf "coefficients" ko show kerwana chahta hun. Aur 10 ki power show nahi kerwana chahta. yani
2.88204
2.91267
2.92247
2.93819
2.9628
.
.
.


sirf coefficients ko lena hay 10 ki powers chor di hain. Chunka data bohut zayada hay is liye main aik aik data points ko lay ker her aik ka exponent remove nahi ker sakta. please is ka koi solution batain.

ya numbers hain is leye aap pahly inhe copy kr k dosre column m le jain aur as text paste karain. phr left function k zrya ise reduce kr lain jitne length aap chahte hain for example

=left(a2,4)

tu ya left side sa pahly 4 no seprate kr de ga.

Dosra alternate method ya ha k agar aap Excel 2013 use kr rahe hain tu sirf Pahly number manual lekhain aur phr Data k Tab m FLASH FILL use karain excel automatically tamam entries ko pahly entry k mutabiq change kr de ga.

regards,

[rahe_wafa20]

syar main ney left function ko istemal kiya hay mager phir woh decimal point chor deta hay. aur sirf pehley 4 digits separate ker deta hay.

[rahe_wafa20]

example 2.88204E15 is main 2.882 deney ki bajay sirf 2882 deta hay. mujey decimal point k sath chaheye.

[syar]

example 2.88204E15 is main 2.882 deney ki bajay sirf 2882 deta hay. mujey decimal point k sath chaheye.

Actually ya number hain jinhe excel apni cell limit ki wajha sa scientific notation m display krta ha. Exel cell m 15 number display krta ha agar length 15 sa brhe gi tu scientific no m show kre ga. Ya aap column ki length brha lain.

aap left function ko divide kr lain 1000, 10000 or hundred, jitne decimal number aap ko chahe.

Agar aap excel 2013 use kr rahe hain tuuse flash Fill Option.

regards