Cell format numeric short

Hello,
How to input cell numeric like:
1k --> 1,000
1.2k --> 12,000
1m —> 1000,000
1b-> 1000,000,000

I remember old version support this way. but current version, i don’t know how.
maybe i forget setting something ?

Thank you :slight_smile:

Previous behavior was a byproduct of the library used internally by Handsontable.

It’s still possible, it just needs a little more code from you. Use any library to parse strings into numbers with beforeChange hook. Here’s an example with numbro that is bundled with Handsontable: https://jsfiddle.net/1wk2macL/1/

1 Like

@wojciech.czerniak
wow! Thanks for reply.
Works like a charm. Thank you :wink: