I am using render tool to split my excel into several ones, but after obtain the result. Data in the cell is partial missing. Such as: my "ID number" is "111222" but after render it is "111". I tried to modify the setting of it. But failed. Anybody knows how to solve this? Thanks.
My setting is as below:

