Thread: custom number format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave F[_2_] Dave F[_2_] is offline
external usenet poster
  
Posts: 187
Default custom number format
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

Reply With QuoteReply With Quote