How to change date format in excel report time stamp
In xa excel report the date in time stamp as mm-dd-yyyy
But i want to show as dd-mm-yyyy
But i want to show as dd-mm-yyyy
Asked 2 years ago
Answers
0
Not my area of expertise, but ”F1” (Help in Excel) should help you with conversion functions.
Typically you place the data gathering (ABB DataDirect) and manipulating/conversion functions in a hidden sheet and reference the data therein from the ”visible” sheet.
Typically you place the data gathering (ABB DataDirect) and manipulating/conversion functions in a hidden sheet and reference the data therein from the ”visible” sheet.
2
HI, I believe you need a particular format to display the date & time in your reports. This can be done in 2 ways:
1. excel sheet generally takes the same format of display as your own system. this format can be changed using "reason & language" option as shown in screen shot 11.
2. If first option did not workout then second method is custom option. In excel Ypu will find one "general" option. click on that 1 pop up window as shown in attached screen shot 12 will come. There You can got the "date" & "Custom" option. That will 100% resolve your date format issue.
1. excel sheet generally takes the same format of display as your own system. this format can be changed using "reason & language" option as shown in screen shot 11.
2. If first option did not workout then second method is custom option. In excel Ypu will find one "general" option. click on that 1 pop up window as shown in attached screen shot 12 will come. There You can got the "date" & "Custom" option. That will 100% resolve your date format issue.
Answered 2 years ago
Add new comment