Open in Excel Numbers to String - please revert the change.

Open in Excel Numbers to String - please revert the change. 
This is bug and not a feature.
Money/decimal/int should be a number in excel and not string.


  • Options
    When exporting data to excel, I have to jump through loops to convert text to numbers. Please fix asap.
  • Options
    Hi @ivanpark777

    Thanks for your post.

    The latest release of SQL Prompt addresses the export to excel issue.

    You can take a look at the release notes and download the latest version here.
    Sarah Beckett| Customer Support| Redgate Software
    Have you visited our Help Center? 
  • Options
    MrLivingroomMrLivingroom Posts: 1 New member
    Decimal still exports to Excel as string... (SQL Prompt version
  • Options
    Roland_BRoland_B Posts: 1 New member
    I do have the same issue. Since Version 10.13. the decimal values do have an issue with the decimal separator. All are converted to comma although they are showing as point in SSMS.
    Excel Error Message is 
    We found some issues with the content.

    <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    <summary>Fehler in Datei 'C:\Users\xxxxx\AppData\Local\Temp\p4ph41gw.tma\Exported results 2023-01-25_09-37-09.xlsx'</summary>
    <repairedRecord>Reparierte Datensätze: Zellinformationen von /xl/worksheets/sheet1.xml-Part</repairedRecord>

    I am using SQLPrompt version and SSMS v18.12.1
    Please go back to the 10.12. functionallity with this and don't try to adopt to language specific notations.
Sign In or Register to comment.