Can't change date format in Excel
Can't change date format in Excel
A problem that is frequently encountered when printing work in our Excel program is that the date text cannot be formatted. Some information can be changed, but some information cannot be changed. Because we typed the date in the wrong format. The solution is not difficult at all. You can follow this article.
The main specified formats
ENG - This format uses the typing method. Month/Day/Year (e.g. 12/31/2222) will be read as December 31, 2222.
THAI - This format uses the typing method. Day/Month/Year (e.g. 31/12/2222) will be read as December 31, 2222.
We can check it ourselves by typing =Today( ) to check the date details of our work. The system will display the results as Day/Month/Year
How to format
Window 7 - Press Control Panel settings, select the Clock menu - Language and Region, Region menu, press Format as Thai.
Window 10 - Press Settings, select the Clock and Time menu - add the date, time and set the region, Region menu, press Format to Thai.
-------------------------------------------------------------------------------------
Interested in online marketing care services | online marketing | complete graphics | can contact us anytime | brand building | online marketing | online marketing plan | brand building | Facebook fan page care | Take care of LINE OA. You can contact us 24 hours a day.
Details of online marketing services
Examples of various brands that we take care of online marketing
---------------------------------------------------------------------------------------
💙 Consult our team 💙
📱Tel : 0840104252 📱0947805680
Office Hotline : 034-900-165 , 02-297-0811 (Monday-Friday)
📨 Inbox : http://m.me/ChatStick.TH
┏━━━━━━━━━┓
📲 LINE: @chatstick
┗━━━━━━━━━┛
or click https://goo.gl/KuzCpM
🎉 See our work at https://www.chatstickmarket.caom/portfolio
🎉 details at http://www.chatstickmarket.com/langrn
Comments