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.

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.

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

"Marcelo" wrote:

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.

or

###,"0"


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=553344

Yes, that worked!!

Thanks!!

"VBA Noob" wrote:


or

###,"0"


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=553344