Thread: Number Format: 1,000,000 = 1
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Number Format: 1,000,000 = 1
You could try a custom format of:

#,,



Kevin wrote:

Hi

Is there a way I can format a number so that a value of 1,000,000 shows 1

thanks
--
Kevin

--

Dave Peterson
Reply With QuoteReply With Quote