TEXT formula help

[skull_eagle]

Hi,

I've written the below formula and it work fine, It works out the Min and max years in a range eg. 1998 - 2000

The problem is when the min and max are the same I end up with 1998 - 1998

Is there any way I can make an adjustment to just show the 1 year when this occurs.

    ActiveCell.FormulaR1C1 = _
        "=TEXT(MIN(R[1]C:R[20]C), ""yyyy"") & "" - "" & TEXT(MAX(R[1]C:R[20]C), ""yyyy"")"

Thanks

 

[Hermanito]

You wanted to clarify things pgc01, but now I'm even more confused

My Office version is English, and so is my Windows, only my regional settings contain Belgium as location. I also use a US-type QWERTY keyboard, as opposed to the more or less Belgian standard AZERTY .

So, my setup is about as English as I can get, why do I still have these comma/semicolon issues then?