1
In other words, if the value of a cell, say A1, is =Date()
, then displayed in cell A1 I will see the date, but then I want B1 to be =FuncText(A1)
, then I want to see 'Date()' displayed in cell B1.
To emphasize, I want to see the text 'Date()', i.e. the six chars ending with a ')' in B1.
You misunderstand me, I want to see the text 'Date()', i.e. the six chars ending with a ')' in B1. – ProfK – 2011-12-20T18:06:14.843
updated my answer, as per your update. – Siva Charan – 2011-12-20T18:24:27.353