Formating Cell

ahsanhussain

Join Date: Wed 26 Nov 2008

Posts: 134
- Share
- Tweet
#1

Formating Cell

19 October 2015, 06:48

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.
Tags: -, 1-, 164, 2010, alikum, asslam, bar, bati, batin, bee, cell, click, cnic, cnics, color, delete, duaon, excel, font, formating, formula, friend, hai, hen, hin, ho, hon, hota, hussain, jameel, ka, ko, kuch, nastaleeq, noori, number, option, plz, purpose, quo, rha, rhi, select, show, sir, size, size=, tab, tu, ]
Yaaram

Administrators

Join Date: Sun 03 Jul 2005

Posts: 25655
- Share
- Tweet
#2

2 January 2016, 18:11

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

Announcement

Unconfigured Ad Widget

Formating Cell

Comment