Make Excel know 1M is 1,000,000
On Jun 20, 11:50 am, Tom Ogilvy
wrote:
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
Thanks. But is there a way to make a rule so I won't have to enter all
manually.
For example, excel should know that 1.2m means 1200000 and 3.873m is
3873000...
|