Hi all,
I'm using the out-of-the-box (OOB) "Download as Excel" functionality on a paging grid in Appian. One of the column values in my grid is a dash (-), which is displayed correctly in the interface.
-
However, when I export the grid using the download button, the dash is exported to Excel as '- (with a leading single quote). It seems Excel is treating it as a text value, but I would like it to appear exactly as -, without the quote.
'-
Has anyone else experienced this? Is there a way to prevent the single quote from being added during export?
Thanks in advance for any suggestions!
Discussion posts and replies are publicly visible
Use a hyphen with extra spaces at the start and end (' - '), Excel treats the value as text rather than a mathematical expression.
Thanks, It worked