Boolean display when Print & Send to Excel

rocopsa
rocopsa Member Posts: 38
in NAV Three Tier
Hi Experts,

I am using NAV2017 and have a question hoping an answer.

I have a list and usually put to excel by the function "Print & Send". On the screen, I can see a Boolean type column displays Yes/No. Yet, when outputted into Excel, it turns into True/False. Is there any way I can change it into Yes/No also in Excel?

Besides, when the decimal places of a decimal value is 0:5, and if the value is 60 (no dec pl), it will become 60. to excel too. Also, any method to turn it into 60 instead of 60.?

Thanks in advance!

Categories