Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Formating Cell

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Formating Cell

    Asslam O Alikum:


    Dear Friend,

    Sir mjy excel mi msla ho rha hai k cell mi CNIC Number likha hi36201-0471064-5 es mi dash (-) show ho rhi hin likn jb es ko formula bar mi dikhta hon tu whna show ni hota plz es k bary mi kuch batin.

    Formating Cell Formula Bar
    36201-0471064-5 3620104710645



    Thanks.

    Apki Duaon Ka talbgar
    Ahsan Hussain.

  • #2
    Re: Formating Cell

    Originally posted by ahsanhussain View Post
    Asslam O Alikum:


    Dear Friend,

    Sir mjy excel mi msla ho rha hai k cell mi CNIC Number likha hi36201-0471064-5 es mi dash (-) show ho rhi hin likn jb es ko formula bar mi dikhta hon tu whna show ni hota plz es k bary mi kuch batin.

    Formating Cell Formula Bar
    36201-0471064-5 3620104710645



    Thanks.

    Apki Duaon Ka talbgar
    Ahsan Hussain.
    Walikumsalam..
    Right Click on cell (in which you see dashes between CNICs) then click on Format Cell then go to Number tab and then Click on Custom and select the option which has been defined for this purpose. Delete it.
    Allah

    Comment

    Working...
    X