The only function that can affect the formatting in this way is TEXT,
but that turns your numbers into text at the same time, which you
might not want if you do further calculations on them.

Hope this helps.

Pete

On Oct 26, 8:59 am, "
wrote:
Is there a way to format a cell say to currency using some function?
yaro