Custom Number Format

M

Millie

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.
 
M

Marcelo

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:
 
M

Millie

No, I already tried both those, it doesn't work.

Marcelo said:
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:
Click to expand...
 
Top