Hi All,
I am generating excel using Export SQL to Excel, and SQL is calling Stored Procedure.
I have requirement that one of my column is decimal format and I want to preserve that format in excel, I need to show that decimal as a % in column.
Any suggestion?
Discussion posts and replies are publicly visible
I'm not 100% sure on this but I expect your SQL could convert/cast the column value to text and add the "%" character after the number if that's what you're after.
Thanks Mike.
But my requirement is that I want that column as decimal number formated which shows the percentage. It should not be the text format.
So what is currently not working correctly for you?
As you suggested I was doing the same, I was casting column value to text and appending the "%" sign to it, But In excel I do not want that column as text formatted. It should be Percent or number format.
Hi priyankag0001
Can you make sure your column/cell of your base excel template is in percentage format. In that way, you don't have to append "%" to your data.
Hi Ankita,
Formatting is already there.
Can you show how your data is currently being populated?