Webhosting in Pakistan
Results 1 to 6 of 6

Thread: Excel data type

  1. #1
    rahe_wafa20 is offline Senior Member+
    Last Online
    14th October 2017 @ 04:16 PM
    Join Date
    10 Jan 2008
    Posts
    294
    Threads
    58
    Credits
    24
    Thanked
    4

    Default Excel data type

    Webhosting in Pakistan
    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.
    Last edited by rahe_wafa20; 6th February 2014 at 05:58 PM.

  2. #2
    rahe_wafa20 is offline Senior Member+
    Last Online
    14th October 2017 @ 04:16 PM
    Join Date
    10 Jan 2008
    Posts
    294
    Threads
    58
    Credits
    24
    Thanked
    4

    Default

    woh log jo excel jantey hain pls madad karain
    Last edited by rahe_wafa20; 7th February 2014 at 05:29 PM.

  3. #3
    syar is offline Advance Member
    Last Online
    19th August 2019 @ 03:17 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    42
    Gender
    Male
    Posts
    834
    Threads
    9
    Credits
    236
    Thanked
    340

    Default

    Quote rahe_wafa20 said: View Post
    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

    Code:
    =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,

  4. #4
    rahe_wafa20 is offline Senior Member+
    Last Online
    14th October 2017 @ 04:16 PM
    Join Date
    10 Jan 2008
    Posts
    294
    Threads
    58
    Credits
    24
    Thanked
    4

    Default

    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.

  5. #5
    rahe_wafa20 is offline Senior Member+
    Last Online
    14th October 2017 @ 04:16 PM
    Join Date
    10 Jan 2008
    Posts
    294
    Threads
    58
    Credits
    24
    Thanked
    4

    Default

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

  6. #6
    syar is offline Advance Member
    Last Online
    19th August 2019 @ 03:17 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    42
    Gender
    Male
    Posts
    834
    Threads
    9
    Credits
    236
    Thanked
    340

    Default

    Webhosting in Pakistan
    Quote rahe_wafa20 said: View Post
    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

Similar Threads

  1. Expired Recover Lost Data
    By smrat_boy in forum English IT Zone
    Replies: 86
    Last Post: 5th March 2013, 06:33 PM
  2. Secure and Permanent Data Deletion
    By general in forum English IT Zone
    Replies: 4
    Last Post: 20th June 2011, 03:18 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •