Forum Discussion
Time format used to work, but not anymore in Excel
Hello.
I have a problem that occured today.
I have Timestamp values in format hh:mm:ss.000 (tt:mm:ss.000 due to my country).
Before (about 3 weeks ago) i could define my custom format and do calculations (time [sec]) with the format, see picture 2. Could also see that the alignment of the timestamp was at the right side, see picture 2.
Today, this did not work anymore. Tried to copy new Timestamp values into old (still working) Excel file, but this did not work either.
So suddenly, Excel wont recognize hh:mm:ss.000 anymore (tt:mm:ss.000 in my country)
Can this be fixed or is there another solution?
Picture 1. Not working:
Picture 2. Old Excel file, still working:
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.
6 Replies
Deleted
Very strange! Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
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.