Hi, Mile

try to custom a format like this 00,0. or 00.0,
depending of decimal separate signal

hope this helps
regards from Brazil
Marcelo


"Millie" escreveu:

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.