Skip to main content
June 3, 2025
Solved

Dash (-) Appearing as '- When Exporting Paging Grid to Excel via OOB Download Button

  • June 3, 2025
  • 2 replies
  • 0 views

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!

    Best answer by shubhama926776

    Use a hyphen with extra spaces at the start and end (' - '), Excel treats the value as text rather than a mathematical expression.

    2 replies

    shubhama926776
    June 3, 2025

    Use a hyphen with extra spaces at the start and end (' - '), Excel treats the value as text rather than a mathematical expression.

    June 3, 2025

    Thanks, It worked