Forum

Notifications
Clear all

In Excel Sheet Date Format not changing to local regional format.

3 Posts
2 Users
0 Reactions
75 Views
(@sashokkumardas)
Posts: 2
New Member
Topic starter
 

Excel-Sheet-1.jpgExcel-Sheet-Date-Setting.jpgRegional-Date-Setting.jpg

Hi Catalin,

You can see the date format in non-us format but still it is not working in my excel.

Please help me.

ASHOK.

 
Posted : 02/08/2017 12:30 am
(@catalinb)
Posts: 1937
Member Admin
 

I believe you should not use default Date formats to cell format. Use Locale formats, otherwise excel will treat defaults as US formats. (second image, chage to locale formats)

 
Posted : 03/08/2017 1:10 am
(@sashokkumardas)
Posts: 2
New Member
Topic starter
 

Hi Sir,

 

Thank you for reply, I uninstall the msoffice and re-install, now it is work good.

 

Thank you,

ASHOK.

 
Posted : 03/08/2017 1:44 am
Share: