How to change format from numeric to text?

Getting help Questions
1

I’m letting users to choose their format and pattern - if a cell had numericFormat and 0,00.00 pattern and if the user puts a text and wants to change the format to text, how to do it? Tried hot.setCellMeta(j, k, “renderer”, “text”); but doesn’t seem to work

2

Sorry for keeping you waiting @anabayan

Here http://jsfiddle.net/43j99mbs/ is an example that may help. If you are changing cell meta (example: setCellMeta) you need to call a renderer to refresh the view.