Results 1 to 3 of 3

Thread: EXCEL MAIN DATE KA MASLA

  1. #1
    faizan374 is offline Senior Member+
    Last Online
    8th July 2016 @ 12:38 PM
    Join Date
    23 Feb 2010
    Age
    43
    Posts
    492
    Threads
    256
    Credits
    10
    Thanked
    8

    Default EXCEL MAIN DATE KA MASLA

    MAIN JAB EXCEL MAIN APNI MARZI KI DATE LIKH RAHA HUN OR JAB ENTER KARTA HUN TO WO APNI MARZI KI DATE DEDETA HAI JAISE MAIN NE YEAR MENTION NAHIN KARNA TO MAIN LIKHTA HUN 22-APRIL OR ENTER KARDETA HUN LEKIN WO 22-APRIL KE SAATH 22-APRIL-2015 BHI DEDETA HAI JABKE MJE YEAR NAHIN LIKHNA PLEASE HELP

    REGARDS

  2. #2
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Quote faizan374 said: View Post
    MAIN JAB EXCEL MAIN APNI MARZI KI DATE LIKH RAHA HUN OR JAB ENTER KARTA HUN TO WO APNI MARZI KI DATE DEDETA HAI JAISE MAIN NE YEAR MENTION NAHIN KARNA TO MAIN LIKHTA HUN 22-APRIL OR ENTER KARDETA HUN LEKIN WO 22-APRIL KE SAATH 22-APRIL-2015 BHI DEDETA HAI JABKE MJE YEAR NAHIN LIKHNA PLEASE HELP

    REGARDS
    By default excel aap ki date k sath year add kr dega. Q k jab aap ko calculation krne ho khas toor par date ka difference nikalna ho tu phr excel ko smjhne m masla hota ha. Aap custom formatting k zarye Year ka digit ya year ghyb kar sakte hain lkn aap ko formula bar m year nazar aai ga. lkn cell m nahee nazar aai gi.


    Cell per right click kr k format cell par jain. Number k tab m CUSTOM
    ko select karain aur "d-mmm" Lekhian aap k cell m year nazar nahee aai ga.

    regards,

  3. #3
    faizan374 is offline Senior Member+
    Last Online
    8th July 2016 @ 12:38 PM
    Join Date
    23 Feb 2010
    Age
    43
    Posts
    492
    Threads
    256
    Credits
    10
    Thanked
    8

    Default

    zabardast syar bhai thanks alot

Similar Threads

  1. Hayat-e-Eisa Alihi Salam Our Quran.(Eak Special Thread)
    By Irfan_shah in forum Khatm-e-Nabuwat
    Replies: 280
    Last Post: 28th March 2021, 12:11 AM
  2. Replies: 48
    Last Post: 13th June 2013, 10:16 PM
  3. xp offline file
    By apna_azmi in forum Ask an Expert
    Replies: 15
    Last Post: 12th September 2011, 06:49 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
  •