another possibility based more on the subject title
than what you asked for in your question by way of the
examples would be to use the asterisk to define a
fill character in this case the fill character is an asterisk.
_(**$#,##0.00_);[Red]_(**$(#,##0.00);_(**$0.00_);_(@_)

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"polletje " wrote in message ...
thnx, works great. Just one little question.
When i copy and paste it in macro, in the destination file it shows
the original value. Is there a way to set the created value to a fixed
value??


---
Message posted from http://www.ExcelForum.com/