Custom Number Format

Giganews Newsgroups
Subject: Custom Number Format
Posted by:  Millie
Date: Mon, 19 Jun 2006

I need to display thousands format (25,000.00) as 250. I can get it to
display as 25.0 by using this format: _(* #,##0.0,_);_(* (#,##0.0,);_(*
"-"?_);_(@_)

I've tried different ones, but can't get it to keep 25000 in the formula bar
and display 250 in the cell.

Replies