.. Both do the job.

In terms of showing / display in the formula cell, yes. But there's a subtle
difference in the underlying values. Formatting retains it as a number,
while using TEXT converts it to text. The underlying value would of course
impact any downstream formulas pointing to that formula cell.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---