एम एस एक्सेल मे date को शब्दों मे कैसे लिखें केवल एक बार फंक्शन का प्रयोग कर

आप फंक्शन का प्रयोग करके date को शब्दों मे लिख सकते है निचे मैंने एक उदाहरण लिया है जिसमे लिखें गए टेक्स्ट को पर्टिकुलर सेल मे शब्दों मे कैसे लिख सकते है इसके बारे मे बताऊंगा अब इसमें दिए गए date को उसके सामने सेल मे day, month aur year me शब्दों  me कैसे लिखें ये बताऊंगा 
इसके लिए day के निचे वाले सेल पर क्लिक करें और फंक्शन लिखें =text(A1, "dddd")
तो day के निचे वाले सेल मे शब्दों मे दिन आ जाएगाअब  month के लिए month के निचे वाले सेल मे जाकर लिखें
=text(A1,"mmmm")
और year ke लिए year के निचे वाले सेल मे जाकर लिखें
=text(A1,"yyyy")

Comments

Post a Comment

Popular posts from this blog

Add two number in Scratch

Image
15.04.2023 Computer Science Secondary School answered Scratch program for sum of two numbers ​ See what the community says and unlock a badge.  to add comment Play Unmute bindroomonika01 is waiting for your help. Add your answer and earn points. Answer No one rated this answer yet —  why not be the first?  😎 Ambitious 15  answers 961  people helped Answer: Here's an example scratch program for finding the sum of two numbers. Explanation: First, drag and drop two "ask" blocks from the “Sensing” category and place them below the “when green flag clicked” block. Change the prompt text on both ask blocks to "Enter a number" and "Enter another number". Drag and drop a "set" block from the “Variables” category, and change the variable name to "num1". Place it under the first "ask" block, and set its value to "answer". Repeat step 3, but change the variable name to "num2" and place it under the second "...
Read more

Change constume of a sprite

To change the  costume  of a sprite (the appearance of a character or object in your program) with Scratch, you can use the « set costume to [costume] » block. Here’s an example of how you can use this block: Start a new  Scratch  project and add a sprite to the stage. In the « Costumes » tab, click the « Import » button to import a new costume for the sprite. You can use an image editor to create your own costume, or you can choose a costume from the Scratch library. In the « Scripts » tab, drag out a « set costume to [costume] » block and select the costume you want to use from the dropdown menu. You can then use this block to change the costume of the sprite when certain events happen, such as when the sprite is clicked on or when a key is pressed. For example, you could create a script that changes the sprite’s costume every time the space key is pressed: Drag out a « when flag clicked » block and add a ...
Read more