Results 1 to 3 of 3

Exporting to Excel Number Format Issue

Threaded View

johnrriggs22 Exporting to Excel Number... 12-13-2010, 11:25 AM
JBeaucaire Re: Exporting to Excel Number... 12-13-2010, 11:30 AM
johnrriggs22 Re: Exporting to Excel Number... 12-13-2010, 11:39 AM
  1. #1
    Registered User
    Join Date
    12-10-2010
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2007
    Posts
    6

    Exporting to Excel Number Format Issue

    At work I have to export a report into Excel. We have some very long quote numbers that get abbreviated to scientific notation in the process. When I click on the cell, I see the entire length of the quote number except the last digit is changed to '0.' Verifying the correct quote number adds considerable work. Is there a way to configure Excel to not automatically change the number format when I export?

    Thank you for your help.
    Last edited by johnrriggs22; 12-13-2010 at 11:40 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1