"Scott" wrote:
All I get with the current code is a dash
(Cell looks like this-----[ - ] )

Think the above is probably just a zero,
display is due to cell formatted as "Accounting"

If you re-format the cell as "General" or "Number",
then the zero would show

When I used the text idea cell looks like [ #value ]
but I expect a certain value that I have calculated.

Try the full alternative expression
suggested to your next response
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--