• 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