Forum

Notifications
Clear all

Date in Excel - How to change a date or region setting?

2 Posts
2 Users
0 Reactions
50 Views
(@usb)
Posts: 244
Honorable Member
Topic starter
 

On my computer the Windows is English and the Excel is Hebrew
As I type in date January 24, 2019
He types me that way - 1/24/2019 as in English
And I need Axel to write like that - 24/1/2019

How do I set the dd / mm / yyyy template by default to Excel?
Thanks

 
Posted : 13/09/2019 12:15 am
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi Lea,

This is controlled by your Region settings in Control Panel.

Your Windows may be set to English but it might be set to English (United States) region hence the mm/dd/yyyy format you are seeing.

Juts change your Region to Hebrew (Israel).

Regards

Phil

 
Posted : 13/09/2019 12:33 am
Share: