My Online Training Hub

Microsoft Office Online Training

Get our newsletter and join over 80,000
people who learn Excel with us every week
You are here: Home / In Excel Sheet Date Format not changing to local regional format. | General Excel Questions & Answers | Excel Forum

In Excel Sheet Date Format not changing to local regional format. | General Excel Questions & Answers | Excel Forum

Avatar
sp_Registration Register sp_LogInOut Log In sp_ControlOpen Unanswered
sp_Search Search
Advanced Search
Search

— Forum Scope —





— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Search Search
sp_RankInfo

Lost password?
sp_PrintTopic sp_TopicIcon
In Excel Sheet Date Format not changing to local regional format.
Avatar
SASHOKKUMARDAS

New Member
Members
Level 0
Forum Posts: 2
Member Since:
August 1, 2017
sp_UserOfflineSmall Offline
1
August 1, 2017 - 2:30 pm
sp_Permalink sp_Print

Excel-Sheet-1.jpgImage EnlargerExcel-Sheet-Date-Setting.jpgImage EnlargerRegional-Date-Setting.jpgImage Enlarger

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.

sp_PlupAttachments Attachments
Avatar
Catalin Bombea
Iasi, Romania
Admin
Level 10
Forum Posts: 403
Member Since:
November 8, 2013
sp_UserOfflineSmall Offline
2
August 2, 2017 - 3:10 pm
sp_Permalink sp_Print

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)

Avatar
SASHOKKUMARDAS

New Member
Members
Level 0
Forum Posts: 2
Member Since:
August 1, 2017
sp_UserOfflineSmall Offline
3
August 2, 2017 - 3:44 pm
sp_Permalink sp_Print

Hi Sir,

 

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

 

Thank you,

ASHOK.

Go to top
Forum Timezone: Australia/Brisbane

Most Users Ever Online: 57

Currently Online:
16 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 651

Frans Visser: 210

David_Ng: 96

mey tithveasna: 71

A.Maurizio: 60

rathanak: 58

yhooithin05: 54

Anders Sehlstedt: 47

julian: 46

PaulFogel: 37

Newest Members:

sugi gunawan

janja mesec

John DiMartino

lizette acosta

eric johnson

Kim Bond

Nichelle Stevens

Manuel Rodriguez

peter wang

Amit Kanekar

Forum Stats:

Groups: 2

Forums: 18

Topics: 935

Posts: 4405

 

Member Stats:

Guest Posters: 1

Members: 42350

Moderators: 1

Admins: 3

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea

Moderators: Genevieve Tupas

YouTube Channel Follow us on Facebook Twitter Follow Google+ RSS Feed or Email

Blog Categories

Resources

Excel Resources

Affiliate Program

Become an Affiliate
Secured by Sucuri Rect
✕
Hang On, Don't Go Just Yet.
Excel Tips & Tricks Book

As a thank you for visiting how would you like a
10% Discount Code to use with any of my courses?

I'll also give you a copy of my eBook packed with
100 Excel Tips & Tricks.

And I'll send you my weekly Excel blog posts.

Enter your email address below to receive all of these.

Regards, Mynda (Excel MVP)

mynda treacy mvp
100% Privacy. We don't spam.
✕
SUBSCRIBE AND LEARN EXCEL
Excel Tips & Tricks Book


Learn great Excel features, tips and tricks each week from my newsletter.

Just enter your email below, and as an extra bonus, I'll send you a copy of my '100 Excel Tips & Tricks eBook' - for nothing!

Thanks,

Mynda

 



100% Privacy. We don't spam.
✕
100 FREE EXCEL TIPS & TRICKS
Excel Tips & Tricks Book


Want to learn more great Excel tips and features?

Enter your email below and I'll send you my weekly blog post.

Plus, by signing up you'll get a copy of my '100 Excel Tips & Tricks eBook' - for nothing!




 

100% Privacy. We don't spam.