I just discovered that when entering a numbers into text entry field (with column type set to ‘Number’), you can type the following letters to add the equivalent amount of 0’s.
“k” = 000
“m” = 000000
“b” = 000000000
“t” = 000000000000
Thats k for thousand, m for million, b for billion, and t for trillion.