LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Prevent Scientific Notation

I am running an Access program that exports data into an Excel spreadsheet.
The problem I am having is that I have a FedEx tracking # field that displays
in scientific notation because it's longer than 12 digits. Since this program
is automated I cannot count on someone to manually change this field to text
before the data is used.

Is there a way to prevent Excel from converting to scientific notation, or
at least change the amount of numbers that must be present before doing so?
Thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Scientific notation from a csv file scott Excel Discussion (Misc queries) 1 October 25th 06 07:59 PM
scientific notation T.Reisz Excel Discussion (Misc queries) 4 June 12th 06 01:59 PM
Truncate scientific notation Topher Excel Worksheet Functions 1 March 21st 05 10:28 PM
Scientific Notation when graphing Bates Senior Thesis Researcher Charts and Charting in Excel 6 March 17th 05 06:58 PM
Scientific notation Clive Excel Discussion (Misc queries) 2 February 8th 05 11:38 PM


All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"