Forum Discussion
Time format used to work, but not anymore in Excel
Deleted
Thanks. What happens if you do the following?
- Select column B.
- On the Data tab of the ribbon, click Text to Columns.
- Select Delimited, then click Finish.
This worked for me - the values are now right-aligned:
Workbook attached.
Deleted
Thanks. What happens if you do the following?
- Select column B.
- On the Data tab of the ribbon, click Text to Columns.
- Select Delimited, then click Finish.
This worked for me - the values are now right-aligned:
Workbook attached.
Hello and thanks for answer!
This is very weird.. I tried your method, but nothing happens.
When i downloaded your corrected "Help with timestamp" execl file, i can do calculations, as seen in picture below:
I tried copy and paste all my timestamps into your corrected file, but that did not work either..
I can try to delete and reinstall Excel, if you dont have any other options?
again, thanks for reply 🙂
Deleted
Has anything changed in your regional settings in Windows?
Reinstalling Office may not be necessary, there should be a repair option:
- Select Start > Settings.
- Select Apps.
- Scroll down the list of apps and select your version of Office.
- Click the ... button on the right hand side and select Modify.
- Hi
Havent changed any regional settings.
Problem not solved, but transfered the data to another computer and did time-calculations.
So i've achieved what i want, but the problem is still a mystery..
Thanks for suggestions 🙂