Post reply

Export to Excel Converts string S/N to Scientific notation

  • May 9, 2012 at 10:12 am

    #147220

    I know this is probably a simple issue, but:

    I have a column of Serial Numbers (Nvarchar(255)) that when I copy the data and dump it into Excel, it gets converted to Scientific notation. The S/N's have (mostly) 2 leading 0's which are being dropped after I've manually converted the field to text, or done something like use the UPPER function to trick Excel.

    any ideas how to prevent this from happening, short of changing the data type on the column?

    Thanks

    Crusty

  • May 9, 2012 at 10:27 am

    #1485186

    Output your data with a tick mark in front. 'data

    This will tell Excel that the data is text.

  • May 9, 2012 at 10:29 am

    #1485188

    I thought about that, but wasn't sure if that would end up being visible in the report... hadn't got around to trying it yet... Guess I'll have to go that route.

    Thanks!

  • May 9, 2012 at 3:03 pm

    #1485364

    CptCrusty1 (5/9/2012)

    I thought about that, but wasn't sure if that would end up being visible in the report... hadn't got around to trying it yet... Guess I'll have to go that route.

    Thanks!

    Have you tried formatting your value as text on the report?

  • May 9, 2012 at 3:12 pm

    #1485368

    Yes, but the idea is that I don't want to touch the data too often. Export, done. Thats it. Not a lot of formatting work, just spit it into a template and off we go.

    Crusty.

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

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