NPrinting Cell Format

[ijulias]

Hi everybody,

I would like to change the number format of a Cell depending on the cell value.

In "Edit Cell -> Format", I've tried to put this, but it doesn't run:

   If (Name_cell > 50, num(Name_cell,'0.0'), num(Name_cell,'0.00'))

Anybody knows if it's possible to do it?

Thanks.

[Frank_S]

Hi @ijulias 

Inside the NP template editor or even outside the template editor a new excel worksheet, try your formula directly on the xlsx spread sheet cell where you inserted the NPrinting tag to or in blank worksheet or try to use the custom format editor in Excel.

If it doesn't work there as a custom cell format, then it surely won't work in the location that you are trying to do it. If it does, then it will hopefully work with NP as well.

Hope this helps....

[Ruggero_Piccoli]

Hi,

Did you unflagged the "Keep Source Format" option? 

If no, select the cell/column in the treeview on the left side then bottom in the properties remove the flag to the Keep source format option only for the specific cell or column.

Best Regards,

Ruggero

[ijulias]

Hi @Frank_S ,

I've tested you said in a new spread sheet and it runs, but in NP it doesn't run...

I suppose I'm doing something wrong...I'll try to discover it.

Thanks a lot!

[ijulias]

Hi @Ruggero_Piccoli ,

I unflagged the "Keep Source Format" option.

Thanks for the advice, I'll try in the way @Frank_S  suggested.