Help with Formula Year, Month and date

[zone709]

HI,
I was trying to put the right formula together to change Month, Day, Year to Year, Month and day.

Example in C1 I have 120721. Need to change it to 211207 - Year, Month and day

 

[jtakw]

The double minus ( or double unary ) works like this, a single minus does the Math of changing the result to Negative, the second minus, changes it Back to Positive, any math done to a text representation of a number turns it into a Real Number ( like the *1 , or +0 )
For Excel, 0 is False, anything other than 0, positive or negative is True.
But that's not why +0 is used here, it's just adding 0 (zero) to coerce the text number to Real Number without changing it's mathematical value, like *1

 

[Peter_SSs]

in Access, 0 is false, but -1 is True.

Same in vba

 

[Peter_SSs]

@Micron
Perhaps also of interest, MrExcel MVP and former (I think) Microsoft MVP Aladin Akyurek contends that -- has a slight performance advantage over some of the other coercers:
Count Function????