CODEWITHSUNDEEP
exceldate
Aayush Desai
Aayush Desai

Reputation: 1

Excel Dates Formatting issue

In Excel

Whenever I try adding days to a date (for eg: 3/15/18 1:50 PM) the result gives me date with two spaces in between date and time. Tried formatting cells, trimming cells replacing space using substring, but nothing worked

Date            Days   New_date
3/15/18 1:50 PM   0     3/15/18  1:50 PM

Upvotes: 0

Views: 55

Answers (1)

Zeph
Zeph

Reputation: 1728

Check to see if you are using a custom number format. You can control exactly how your date is formatted here, and there could be an extra space between the date and the time.

enter image description here

Upvotes: 1

Related Questions