Post reply

excel destination format

  • April 14, 2015 at 9:12 am

    #1790850

    For the columns that show "####", have you tried expanding the column width in the worksheet?

    As for the $ sign - you have set the Amount columns to be currency, that's probably why. If you don't want them with a $ sign export them as something else.

    I'm on LinkedIn

  • April 14, 2015 at 9:30 am

    #1790857

    so what data type i should give so that it wont come as $ in my excel sheet

  • April 14, 2015 at 9:37 am

    #1790863

    coool_sweet (4/14/2015)

    so what data type i should give so that it wont come as $ in my excel sheet

    Anything other than currency if you want to avoid the dollar sign. If you still need to use it as a number (for calculations and such) then export it as a generic number. If it doesn't matter, then text.

    Read this and you will find a whole list of options: https://msdn.microsoft.com/en-us/library/ms137643.aspx

    I'm on LinkedIn

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply