View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default Formating question

This Custom Format should work for you...

$#,##0",000"

--
Rick (MVP - Excel)


"rk0909" wrote in message
...
All,

Is it possible to create a style where a number which is actually in
millions of $s appear as thousands of dollars.

e.g. if input is in millions and lets say I enter 100 and I want to see
the
output in thousands (without changing the input physically) cell should
show
100,000.

Thanks much,

RK