Quicker/Easier Data Entry

Options
Tom.Wahl
Tom.Wahl Member, ALL USERS, Employee, Certified Model Builder Posts: 1 Occasional Contributor

Ability to utilize "k", "m", and "b" with data entry, so for example if I enter 1k in a cell, the result would be 1,000. if I enter 1.2k, I get 1,200. if I want to enter 1,000,000 in a cell, instead of typing 7 characters, i would type "1m". If I type 1.2M, the value entered would be 1,200,000, if I entered 1.25M, it would be 1,250,000, etc. Would also expect it to work for billions. Thanks.

Tagged: