- Feb 27, 2006
Is there any way of making Excell as clever as some of the old spreadsheets who could automatically differentiate text (ie letter and letter number combinations) from numbers and formulae ? I cant believe that a program as massive as this cannot contain a few lines of code to examine imput and decide if it is a number, text or formulae. There was a way of forcing the old programmes to regard a number as text by using quotes, as today, but if one typed 3*7 they would know you wanted 21. Is there a "switch" somewhere that I havent come accross, or MUST I type a "=" before each and every calculation.