View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default custom number format

Format Custom
0.00,,

--
Gary''s Student - gsnu2007


"Dave F" wrote:

Say I have 3,510,00 in a cell.

How can I have it displayed as 3.51?

I realize I can just multiply by 10^-6 but I want to keep the
underlying millions.

Thanks,

Dave