Тёмный

Convert Date From Text to Date Format In Excel | Excel Hacks | Excel Tips & Tricks 2022 

Gyani Abhijeetji
Подписаться 76 тыс.
Просмотров 209 тыс.
50% 1

Convert Date From Text to Date Format In Excel | Excel Hacks | Excel Tips & Tricks 2022
About Video
Namaskar Dosto aaj aap is video mein sikhne ja rahe hai ki agar aapke pas excel mein dehr sair date di gayi hain aur aapko identify karna hai ki humara date ka format text hai or date format to is video se aapko help milne wali hai aur agar aap koi date ka format change karna chahte hain to bhi aap easily kar payenge is short video ko dekhne ke bad
Disclaimer:--
Note: Copyright Disclaimer Under Section 107 of the Copyright Act 1976 allowance is made for "fair use" for purposes such as criticism comment news reporting teaching scholar ship and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use....
Aasha karta hoon dosto aapko humare video pasend aaya hoga agar video aachha laga ho to humare channel ko subscribe karke bell icon ko press kar lijiyega kyonki hum apne channle per is type ki video lekar aate rahte hai.
#short
#exceldateformat
#gyaniabhijeetji

Опубликовано:

 

14 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 43   
@rajumaurya9469
@rajumaurya9469 7 месяцев назад
bahut time se pareshan tha., apne sari problem solve kar diya.. bahut bahut dhanyawad
@kazimubashshir
@kazimubashshir 2 месяца назад
Thank you so much. Thats what exactly I was looking for and you saved tons of my time and strain to my fingers bro. I was tired doing f2+ enter lol!!!!
@being.siddhesh
@being.siddhesh Год назад
Thank you So Much It was very very helpful for me
@GyaniAbhijeetji
@GyaniAbhijeetji Год назад
Wlcm
@pandhusangaji3050
@pandhusangaji3050 Год назад
sukriya sukriya....
@thananjeyankandeebanthanap6041
You saved my life 😊 Thanks a lot Bro 🙏🏾
@GyaniAbhijeetji
@GyaniAbhijeetji Год назад
Wlcm if you want to learn more then you have join our course in only rs 699 Download our app from Play Store App name -abhijeetji technical 4m
@bhargavsainizampatnam2905
@bhargavsainizampatnam2905 Год назад
Worked👍
@jiwansangeet7431
@jiwansangeet7431 9 месяцев назад
I m beginner, months bhi different hai sabhi cells me tab bhi yahi use kare ? Please help
@rockyaalam2878
@rockyaalam2878 Год назад
Nice 🎉
@bck4589
@bck4589 Год назад
mere data me first month, middle e month and last me year text format me hai use dd/mm/yyyy me karna hai. please help
@GyaniAbhijeetji
@GyaniAbhijeetji Год назад
Do bar month kaise ho sakta hai galat question pooch rahe
@bck4589
@bck4589 Год назад
@@GyaniAbhijeetji sorry, first me month, middle me date and last me year text format me hai
@Hopscotchian
@Hopscotchian Год назад
what if text date is in mm-dd-yyyy hh:mm:ss format? will it still work?
@GyaniAbhijeetji
@GyaniAbhijeetji Год назад
Yes still work
@RajnathChatterjee-ug4bh
@RajnathChatterjee-ug4bh Год назад
Yeahi cheez agar pure coloumn k liye karu toh kaise karu? Almost 15,000 rows hain..... ghanta bhar drag thodeye kar sakta hu
@GyaniAbhijeetji
@GyaniAbhijeetji Год назад
Bhai mere r u beginner in Excel I think drag karne ki koi jaroorat nhi simple double click kar do formula automatic niche Tak fill ho jayega Bottom right mein aakar double click kar do aur sikho chiso ko
@RajnathChatterjee-ug4bh
@RajnathChatterjee-ug4bh Год назад
@@GyaniAbhijeetji Thank you
@digitonic121
@digitonic121 Год назад
Vedio jab bhi banaow slow and short banao
@vaibhavsharma5226
@vaibhavsharma5226 Год назад
@dk1inall
@dk1inall Год назад
Maza
@maxlindgren5795
@maxlindgren5795 11 месяцев назад
Doesnt work, my column is in text and contains (11-7-2023) when i do a column with formula =DATE(YEAR(A3);MONTH(A3);DAY(A3)) I get a error #VALUE!
@GyaniAbhijeetji
@GyaniAbhijeetji 11 месяцев назад
You typed wrong formula You are typing semi colon (;) don't type semi colon you have type comma (,)
@maxlindgren5795
@maxlindgren5795 11 месяцев назад
@@GyaniAbhijeetji no, that depends on regional settings and my excel is using semicolon as a separator.
@GyaniAbhijeetji
@GyaniAbhijeetji 11 месяцев назад
@@maxlindgren5795 where r u from
@maxlindgren5795
@maxlindgren5795 11 месяцев назад
@@GyaniAbhijeetji Sweden 👍
@SovanSheet-yw6gp
@SovanSheet-yw6gp Год назад
Kon sa chosma lagua Tara video dak na ka Lea ....???text to date formula?
@GyaniAbhijeetji
@GyaniAbhijeetji Год назад
God ne jo chasma Diya hai aapne usko bekar kar Diya hai to aapko use sudharne ki jaroorat hai Khoob green vegetable aur carrot 🥕 khane ki jaroorat hai best of luck
@saybashah9008
@saybashah9008 Год назад
4 feb 2023 ko 4/02/23 mai kaisy convert karwn?
@GyaniAbhijeetji
@GyaniAbhijeetji Год назад
Right click then select format cell then click on date format then select format according to your requirement still facing problem let me know
@MRNaidu1978
@MRNaidu1978 Год назад
From 21/02/2023 to change 21-02-2023 Please send formula
@GyaniAbhijeetji
@GyaniAbhijeetji Год назад
Use Substitute formula
@yashankit7167
@yashankit7167 Год назад
press Ctrl+1 select date option
@yashankit7167
@yashankit7167 Год назад
or select custom remove general write 00-00-000 enter
@muscatbranchoman2042
@muscatbranchoman2042 Год назад
Where is TEXT.... it is NUMBER FORMAT
@GyaniAbhijeetji
@GyaniAbhijeetji Год назад
No number format is different Text format that means when u type any alphabet then it's called text format
@praveen9929
@praveen9929 Год назад
Name error
@GyaniAbhijeetji
@GyaniAbhijeetji Год назад
Watch carefully then apply formula
@redmione9791
@redmione9791 Год назад
Kya huwa kisi ko kuch samjha kya. 😅
@Mk-rd4ce
@Mk-rd4ce 11 месяцев назад
Nhi bhai copy past 😂
@Knowledge-wf2vw
@Knowledge-wf2vw Год назад
Date se text kahan hua hai
@GyaniAbhijeetji
@GyaniAbhijeetji Год назад
Date text ke form mein ho jayga
Далее
Outsmarted 😂
00:20
Просмотров 2,3 млн
How to Autofill Dates in Excel (Quick and Easy)
4:01
🔥Don't Use Formula | Use Excel Magic Trick Ctrl+E
9:19
Change dates from mm dd to dd mm Format and Vice Versa
10:44