Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
sarfaraz_sheikh
Contributor III
Contributor III

Exel formating is not working in Template Editor

Hi Folks,

I have dragged and dropped required columns in template editor and i want to do the Exel formatting on that ..However exel formating is working except percentage column.

I have done the below things for percentage column but did not get as expected;

- I have deselected "Keep source Formats First"

-I have written #,##0.00% in format option under Propeties.

- I have selected percentage column and choose format Cell and then after under Number tab i choose percentage option ...but that also did not work.

Below is the snapshot for clarity.  is there something which i missed to configure.

Help would be much appreciated.

Thanks

Sarfaraz

Nprinting.png

1 Reply
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

First of all remove your #.##0.00% formatting and execute report to see how is your data translated - is it text (green triangle in the cell corner or just number)?

Once you have this done and once you are sure that your cell returns number (and not text) then apply excel formatting to %

regards

Lech

ps - maybe prepare screenshots of steps with results so if it is still not working then we will look at it further

cheers

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.