Question: what is the difference between text and value in excel?
Answer: Text is the formatted cell's displayed value; . Value is the value of the cell possibly augmented with date or currency indicators; . Value2 is the raw underlying value stripped of any extraneous information. If you are processing the cell's value then reading the raw .