numuric error when input a number in TM1 websheet

[wang_chris]

TM1web reports numuric error when we try to input a number in the cell of websheet, the original value of this cell is 0, but due to the effect of no show of zero in excel setting, the cell seems in blank.

Same input works fine when the cell has a number before input.

How can we fix it?

Regards,
Chris

[tomok]

I don't know the exact answer to tell you but I do know that the problem lies in the cell formatting you've applied to the cell in Excel. I've encountered this many times. You're just going to have to play with the formatting to get a setting that won't mess up when published in TM1Web.

[declanr]

In addition to what tomok has said I've also seen this a lot of times but normally with date cells... TM1 Web and Date Formatting can be... "fun".

Never set number cells to show as a blank though; using dashes to represent zeroes has always worked fine for me.

[wang_chris]

Thanks, all.

When I changed the cell type to Accounting in excel, everything looks fine.