opening text file converts numbers to scientific notation

If I open a text file containing 13-digit barcode numbers for stock using 
Excel 2007, the numbers are converted to scientific notation. I don't have 
the option to specifiy that I want 13 digits with no decimals, but I believe 
this was possible in earlier versions. Is there a workaround or a preference 
i am missing?
0
Utf
3/22/2010 2:35:01 AM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
1238 Views

Similar Articles

[PageSpeed] 32

On the "Home" tab in the "Cells" group, "Format", then "Format Cells", 
"Number" tab, "Number", zero decimal places.

Some hints on 2003 to 2007 command mapping:
http://office.microsoft.com/en-us/excel/HA101491511033.aspx
http://www.rondebruin.nl/0307commands.htm
http://www.computerworld.com/action/article.do?command=viewArticleBasic&articleId=9028218
--
David Biddulph


"Ken Clark" <KenClark@discussions.microsoft.com> wrote in message 
news:831188A6-043C-4FF0-A910-F7CD76810DAA@microsoft.com...
> If I open a text file containing 13-digit barcode numbers for stock using
> Excel 2007, the numbers are converted to scientific notation. I don't have
> the option to specifiy that I want 13 digits with no decimals, but I 
> believe
> this was possible in earlier versions. Is there a workaround or a 
> preference
> i am missing? 


0
David
3/22/2010 6:37:27 AM
Reply:

Similar Artilces:

Problem: "Debug Assertion Failed", File:afxcmn.inl
Hi, I have created an ActiveX ocx control in VC++6.0. When I run it in an ActiveX container of TSTCON32.exe. (the one that is shown while debugging) it runs perfectly. Iam trying to include it in a webpage (I am using visual-interdev for web page creation) by first customizing the toolbox for that ActiveX control and then dragging it to the web page from the toolbox. As soon as I drag it to the webpage, the IDE crashes with a message "Debug Assertion Failed", File:afxcmn.inl Can u suggest me why the problem is occurring and whets the probable solution. Thanks in advance Vijay...

File Dialog in access 2007 01-11-10
Im having problems with the following code in access 2007. I'm trying to open a file dialog to place an image into a form. Any help would be appreciated Reghards Rob. Sub getFileName() ' Displays the Office File Open dialog to choose a file name ' for the current id record. If the user selects a file ' display it in the image control. Dim fileName As String Dim result As Integer With Application.FileDialog(MsoFileDialogOpen) .Title = "Select Picture" .AllowMultiSelect = False .Filters.Clear...

how do I link a text box on a chart to a specific data point?
I have a text box in a chart that I want to move with the data, as additional data is added to the chart. For instance, if the datapoint is January 5, 2008, as I add additional days, I want the text box associated with the January 5, 2008 datapoint to move with the graph. Hi, Text boxes don't track with the data. Replace the text box with a Data Label. Select a single point in a series that is near the location of the text box. Choose Format, Selected Data Point, on the Data Labels tab turn on Value. Click OK. Select the data label and type the text that was in the Text box. ...

Using VLOOKUP and text
I am using a Vlookup function to find dollar values, dates, and names of vendors made within a department. The dollar values are appearing correctly, but the dates appears as "01/00/00" when the field is empty and all the text strings appear as "0" even though there is a name in the source sheet. I have changed the formatting of each cell to be correct to the appropriate format (accountancy, date, text) and even tried 'general' to fix this text problem to no avail. HELP!! If A1 is empty, and you put this in B1: =a1 You'll see it returns a 0. Same thing...

How do you check on Vista if .exe file is 32-bit or 64-bit?
Assume 64-bit Vista and assume that you do not want to run/ execute .exe file. Is there a utility that will read an .exe file and provide specifics like 32-bit or 64-bit code? I can use VS2008 to open any .exe file and it will display a lot of info included there but none indicates if the code was compiled as 32- bit or 64-bit >Is there a utility that will read an .exe file and provide specifics >like 32-bit or 64-bit code? depends (www.dependencywalker.com) or dumpbin /HEADERS Dave ...

number formatted cell
If I am typing in 19 numbers in a cell (that has been formatted to number) to keep track of account numbers, it puts zeroes at the end and only 15 numbers are showing. If I go into another cell and choose text first before typing and then type my numbers you can see all the numbers, but when I try to go and change the number formatted cell to text the number still does not change unless I retype the number. Is this the way this works? yes excel only keeps track of the first 15 digits in a number, if you entered more digits as a number,they are now lost. "Pam Coleman" wrote...

Round up to next half number
I am trying to round up a number to what I recall from school days to be "correct to the nearest half". In other words, if the cell value is between 3.01 and 3.49 I want to round it to 3.5. If the cell value is 3.5 to 3.99 I want it rounded to 4.0 I have managed to round up and down to the nearest whole number but can't figure out how to get it to the nearest half! Can anyone help, please? RMB How's this =ROUNDUP(A1*2,0)/2 best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "rmb4253" <rmb4253@discussions.microsoft.com>...

Open Items
I have a client that uses open items for things like shipping. They have the price set to $0.00, and it marked Must enter price at the POS. The problem is when they put the price in it changes back to $0.00, and they have to put the price in again. I know this will happen if the item is on sale, but it's not. Anyone else have any ideas? This is a multi-part message in MIME format. ------=_NextPart_000_0037_01C92AFD.F5BBAE20 Content-Type: text/plain; charset="Utf-8" Content-Transfer-Encoding: quoted-printable If you are using Price levels, that is the source of the probl...

Excel 2007
On Windows XP SP2 using Excel 2007 I am unable to print from the Open file dialogue. Here is what I am doing: Clicking Open from the Office button Navigating to the file I would to Print Highlighting the document Selecting Print from the Tools menu in the lower left hand corner of the dialogue box The error message I receive states: Cannot print file. It then gives a series of possible reasons, none of which apply because I can print the document if I open it first and then print it normally. Also, I can use the above sequence to print the document if the document is already open. This ser...

Mac OSX How to open a .pub image.
I received an image in the .pub file format from a non-computer literate person. In what program can I open it, or to what program can I import it to - being on Mac OSX 10.3.9 as I am? Thanks! --Doc. On 7/15/05 6:30 PM, in article BEFDB139.E017%drcocktail@bigfoot.com, "DrCocktail" <drcocktail@bigfoot.com> wrote: > I received an image in the .pub file format from a non-computer literate > person. In what program can I open it, or to what program can I import it to > - being on Mac OSX 10.3.9 as I am? It won't open in anything on the Mac. It needs Microsoft Pu...

Making Folders Stay Open?
I have a couple of Personal Folders that I would like to stay open at all times. Mainly, I would like them to be open when I start Outlook 2003. Is there any way to set up a folder so that it stays open? Thanks, -barry Only your default folders. The other personal folders you will have to expand manually. --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal account will be deleted without reading. After furious head scratching, Barry F Margolius asked: | I have a...

Money 2004 standar didn't convert Money 2000 delux file
Hi all, I just installed Money 2004 Standar on XP. I just buy it. I used to have a Money 2000 Deluxe. When I try to convert my data file, to work with Money 2004 the program makes a copy of the file with the extension "MN8" and then stops with the error: "Money cannot convert the file" Is there any way I can Convert the file even if the previous version was a Delux and the new is an Standar version? Thanks Fernando Sainz ...

Publisher can't open a file it just created
Working with Publisher 2003 we just reinstalled it on a computer because it started have problems opening publisher 2003 files. If I create a new file in publisher then save it, when I try to open it again it tells me that it can not open this file. Has anyone else run into this? It happened on another computer once before and we formated and reinstalled windows. I'd like to not have to re install windows if I can help it. Chris Are you saving the file to the hard drive? Do you have Norton? If so disable "script blocking" and in Norton's options disable "Of...

adding largest numbers
I want to add the largest five numbers in a range, which will change daily. I have put a condition on to highlight the top five and that is working. I don't know how to add the largest five numbers since the largest 5 numbers will change from cell to cell daily. I am assuming you would use a SUMIF, then range, but how do you write a critieria for the largest five numbers? Thanks for helping a beginner. Try this, =SUMPRODUCT(LARGE(A1:A100,{1,2,3,4,5})) HTH Regards, Howard "nrbrtsn" <nrbrtsn@discussions.microsoft.com> wrote in message news:5E0744A0-...

had a virus, now cannot open IE
I have icons on desktop..try to click aol or msn icon get reply cannot find file....same with trying to open from start..I had Total PC Defender and finally got rid of it with Malwarebytes. Did I delete something that maybe I shouldn't have? Chicken wrote: > I have icons on desktop..try to click aol or msn icon get reply > cannot find file....same with trying to open from start..I had Total > PC Defender and finally got rid of it with Malwarebytes. Did I > delete something that maybe I shouldn't have? First, we need to know the name of the malware. O...

Insert a file path as a hyperlink
Is there a way to browse and select the file path and insert it as a hyperlink like in Outlook 2000? Like, in what application? --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal account will be deleted without reading. After searching google.groups.com and finding no answer, Brooke asked: | Is there a way to browse and select the file path and | insert it as a hyperlink like in Outlook 2000? First, you have to select HTML from the Format menu. Then, type or past...

A way to link master pages from a master file in publisher?
Is there a way to create a master file (i.e. a template) and link it to several publisher files? That way if the border etc... changes inthe master file, it is updated in all the other linked files. I have figured out master pages, but the files get way to big if I want to contain my entire portfolio on one file. ...

Activities not converting
When converting a Lead to an Opportunity all data is brought across except whatever Activities have been entered previous to the conversion. We are running CRM 1.2 (no fixes). This is how the application was designed to operate. The activities remain with the Lead, as they relate to the Lead itself. However, there is a link in the Opportunity Admin tab back to the originating lead for where you can then drill-down to the activities for the lead. Kind Regards Eddie Fourie MBS Specialist (Available for outsourced projects) -----Original Message----- From: Brian Shelden [mailto:BrianShel...

Sharing outlook express files
If this question is to the wrong ng apologies and please point me in the right direction! I have two computers, both running XP home, linked through a recently acquired Dell wireless router. I want to be able to use either machine for email, using the same email files. The older machine has my email .dbx files. I have shared the folder concerned and made it writable. On the newer machine (laptop) I use Outlook express tools->options->maintenance->store folder and point it at the folder on the other machine. Tells me it will happen next time I restart Express...but nothing happens, ...

How do I read text file in an EXCEL SHEET
Hello, With regards to EXCEL how we read the text file in EXCEL sheet using MACRO. The file is located in d:\Sql\Documents\Amit\log.txt. I want to save the EXCEL sheet, and every time when I open this sheet it reads this text file and displays the contents of this text file in Excel Sheet. I want to use MACRO for reading this text file.How I do that? Thanks Amit fileName = "D:\Sql\Documents\Amit\log.txt" Workbooks.OpenText FileName:=fileName OR Workbooks.OpenText FileName:=fileName, Origin:=xlWindows, StartRow _ :=1, DataType:=xlFixedWidth, FieldInfo:=Array( _ Array(0,...

Error Opening archive .pst
I have archived several years worth of Outlook data. I have created an archive file for each year, and moved the archives to CD. The file does not span CD's. The archive files were created some time ago, and I get an error when attempting to open them. Access denied. I opened them before... What is the trick...? Is it because they are on CD now...? or is it because I have migrated to a new version of Outlook (2003)...? or is it because I have changed user names from my business address when the archives were created to my personal outlook program at home...? i.e. userid changed..? ...

Non specific error on opening Outlook 2000 on Windows 2000 Pro system
"Cannot Open Microsoft Outlook. A program error has occurred. Quit Outlook and Windows and then start again." This happens with all profiles on the system. I've repaired Office, reinstalled Office, then uninstalled and reinstalled Office (and redownloaded and applied all patches). It still errors. Other Office apps open just fine. Outlook does connect to the Exchange server, since I can configure services and it recognizes the LAN ID. Any thoughts? Does it start in safe mode, go to Start > Run > type "Outlook /safe" without the quotes "Paula&qu...

>>>Live Chat
On October 4, 2007, the Microsoft Dynamics Retail Management System (RMS) team will host an Open Forum Live Chat. In this chat, our experts will take questions on any Microsoft Dynamics RMS topic. If we get a high volume of questions during the Open Forum chat, our experts might not be able to respond to all of them within the chat timeframe. In that event, our experts will respond after the chat ends, to the extent possible, and their answers will be included in the transcript for the chat. The transcript will be posted to the using page.http://www.microsoft.com/dynamics/rms/using Si...

excel not updating text boxes
i have several charts with textboxes lind to specific cells within my workbook. inside these cells are formulas that calculate values that I am trying to display on my charts in the text boxes. My calculations are set to automatic, but these text boxes are not updating unless i click in the formula bar for each of them and hit "enter." since i have several charts i don't want to be doing this hundreds of times a day. I have a total lack of confidence that my chart text boxes are displaying the correct values. is there some way to force them to update, maybe wit...

Lost file
My daughter turned off my computer before I could name/save a file in Excel. Will a temp version of it exist anywhere? Thanks! ...