Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

date and time format automatically changing

0

my excel has many tables. when i every time open or uptate excel sheet number or general format changed date or time format. what i do? very difficult using of this sheet.

again and again changed my needful format.

Post Edited
Title: Title was not descriptive.
Answer
Discuss

Answers

0

Most likely you have a formula that returns the current date/time such as =NOW() or you have a macro that updates everything when you make a change to the sheet.

You can look for that formula in the spreadsheet or check any macros that you have running.

It's impossible to know the cause of the issue without you uploading the file in question.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login