Date Format

[rohitnigade]

Hello,

I've been facing an issue with the below set of data, where the first cell has date and time (auto-generated) by my web portal which is formatted as General by default and the second cell is where I have added the date and time myself (manually) using Custom format 'dd-mm-yyyy hh:mm:ss'.

Now this set is being used for some other purpose by another program, which reads the auto-generated correctly, but fails to read the time from the manual entry. So I tried converting the manual entry to General format, but it does not work.

How do I match the formatting of below cell to be similar to the one above?

Yellow.xlsx
	V
1	Date
2	31-07-2023 13:58:39
3	25-07-2023 12:23:24
Sheet1

 

[Joe4]

Duplicate to: Match Formatting

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.