Thread: Make Excel know 1M is 1,000,000
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 6,953
Default Make Excel know 1M is 1,000,000
Tools=Autocorrect options . . .

--
Regards,
Tom Ogilvy



"amirstal" wrote:

How can I make excel know that when I type 1M in a cell the number
1,000,000 should appear in that cell (2M will appear as 2,000,000
etc)?

Thanks,

Amir


Reply With QuoteReply With Quote