Dec 07 2019 06:03 AM
I have seen some funning things in my time but I cannot seem to get around this (Excel 2019 local app)
A table with heading all formatted using @ so should be all text but if I enter 1- and then any number I get, for example entering 1-5 it comes out as 1-52 (by the way it is still formatted as @ in the formatting dialog) perplexed :-), challenge to anyone to explain why it formats to General Number format when it is actually Text formatted using @ in custom format
Dec 08 2019 10:42 PM
Hi @Gavrea
All Table columns must be unique so if there is already a column 1-5 then it makes the new column 1-52
If you added another column 1-5 it would convert to 1-53 etc
Dec 23 2019 02:46 PM