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
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.