Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
a bit like this
https://www.mrexcel.com/forum/excel-questions/523890-how-remove-slashes-date-convert-number.html
To clarify, you want 01/03/2017 to show what exactly? (the examples from the link confuse me)
01032017 - (can't be a number with a leading zero)
1032017
or
132017
If the first as text, try
=LEFT(Date23, 2) + MID(Date23, 4, 2) + YEAR(Date23) + ""
and then for the second, convert to number
=VALUE(LEFT(Date23, 2) + MID(Date23, 4, 2) + YEAR(Date23) + "")
for the last, try
=VALUE(MONTH(Date23) + "" + DAY(Date23) + YEAR(Date23))
or you can mix and match those.
LEFT and MID return numbers. MONTH, DAY, YEAR return numbers. The "" is used for force the numbers to be treated as text.
I hope that helps.
Craig
