Nprinting Doesn't display date format

[lior_malcka]

Hello,

my Nprinting suddenly started to present dates as numbers, I tried to reinstall Nprinting but its still showing the numbers.

The function show the date but on the excel I see numbers

Help please,

Thanks

[#2]

Right click on the Excel cell and then Format the cell to show as a date.

If that doesn't work, then use =date(today(),'mm/dd/yyyy') as your formula.

[Anonymous]

You can use the date format command right in your formula on the Nprinting side.

You can orient to MM/DD/YYYY or several other combinations to get what you want

[lior_malcka]

hey its working but only on excel, if i try to work on powerpoint or pixel perfect I see numbers.

thanks

[lior_malcka]

Not working

thanks

[#6]

Which method did you use to get it to work in Excel? Did you change the cell formatting, or did you change the formula?

[Anonymous]

It appears that you have an older version of NPrinting.  Should not be a reason why the date formula won't work.   As a work around, you can try to create a variable in your QV app with this data formula.  Make a text box to show the variable so that you can see the correct format.  You can then add the variable to your Excel Template.

[lior_malcka]

I changed the cell formatting in the Excel.

[Anonymous · Accepted solution]

Try :

=text(date(today(),'mm/dd/yyyy') )

[psankepalli]