Excel tips and tricks | Percentage format Pro tips. #excel #youtubeshorts #shorts

Excel tips and tricks | Percentage format Pro tips. #excel #youtubeshorts #shorts

Hello Friends,

Excel tips and tricks | Percentage format Pro tips.

Aaj hum baat kerne vale hai yadi aap ko kuch asha data de diya jaayy. Jisme kuch text aur number hoo, aur ye bola jaay ki sabhi number ko percentage mee convert kigiye. Jesa hi aap sabhi numbers ko percentage mee convert kerte hai too aap dekhte hai ki vo sabhi 4 digits mee ho gay, jabki hame 2 digits mee data chahiye tha, ab yadi hum manually change kerte too kafi time lagega. So iss kaam ko aasan kerne ke liye hum yaha per use kerne vale hai ek interesting excel trick koo. Iske liye hum sabhi numbers ko select kernge aur CTRL 1 press kereneg, hamare samne format cells ka dialog box khul ker aajayega jispr hame custom mee ja ker type kerna hai 0% aur ok press ker dena hai. Ab hum dekhte hai hamare sabhi percentage numbers 2 digits mee ho gay hai.

Ashi aur bhi interesting videos ke liye channel subscribe jarur kare. And video pasand ayy too like-share jarur kare.

Thanks

#msexcel #excel #youtubeshorts #viral #shortsfeed #excelshortcut #microsoft #excelshorts #shot #exceltutorial #shorts

Close Menu