Thread: Make Excel know 1M is 1,000,000
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
amirstal[_2_] amirstal[_2_] is offline
external usenet poster
  
Posts: 18
Default Make Excel know 1M is 1,000,000
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