Why does excel convert my text quot;6990011011234quot; to quot;6.99E 12quot;?－software｜痞客邦

Aug 28 Tue 2007 20:39
Why does excel convert my text quot;6990011011234quot; to quot;6.99E 12quot;?

close

Why does excel convert my text for example quot;6990011011234quot; to quot;6.99E 12quot;?
I am runing a quot;import to excellquot; from a web site. When imported, the
identification # is changed to #.###E ##.

Excel doesn't know it's text.

Either put an apostrophe in front of it:
'6990011011234

or change the number format of the cell:
Formatgt;Cellsgt;Number tab
Category: TextDoes that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;pjquot; wrote:

gt; Why does excel convert my text for example quot;6990011011234quot; to quot;6.99E 12quot;?
gt; I am runing a quot;import to excellquot; from a web site. When imported, the
gt; identification # is changed to #.###E ##.

software

software

software 發表在痞客邦留言(0) 人氣()

E-mail轉寄

全站分類：不設分類
個人分類：title
此分類上一篇： calculate time periods
此分類下一篇： Req help matching values across columns in Excel
上一篇： copy amp; paste formula between spreadsheets
下一篇： I can't change border for cell

歷史上的今天

2007: query for work help! showing final result
2007: HOW DO I RE-NUMBERED MY NUMBER COLUMN AFTER I ADDED ROWS?
2007: Duplicating cell value between worksheets
2007: Add comments into email body using VBA
2007: Footer Defaults
2007: Sharing Data Between Worksheets
2007: Excel
2007: Command Button Assignment
2007: How do i not plot values as zero?
2007: returning specific text only
2007: Auto Pareto Chart
2007: 2nd post
2007: How can I get excel to show ALL lines of wrapped text?
2007: Problem with Windows in Taskbar command
2007: how do i round to the nearest 0.5 in excel
2007: How do I print a column of number in COLOR?
2007: print and print preview not active in file drop down
2007: Lockup in Office
2007: Get a Worksheet name through a function
2007: Pocket Excel
2007: mail merge to include signatures
2007: Formatting Cell To Display Value Instead Of Formula
2007: display dates with ordinals
2007: Excel menu bar missing
2007: random plotting
2007: Totals skipping columns
2007: Find precentage result
2007: Newby questions
2007: custom event
2007: Macro in excel to save to an unmapped drive !
2007: combination charts
2007: how do i find palindromes using excel?
2007: Pasting from Excel should let me to show references
2007: Run a macro from cell select
2007: ncaa template
2007: Very strange error
2007: Furmula Dependent Cell References
2007: x-axis is time ... sort of
2007: Collecting weekly and monthly totals from daily data
2007: which line mercy script
2007: removing duplicate rows
2007: missing personal.xls file ... please help!
2007: Unwanted Links
2007: HOW DO I DELETE SHAPES THAT ARE IN SPREADSHEETS?
2007: Delete empty rows from print in Excel
2007: How to have multi plots in one chart or graph?
2007: Grid column display text trimming
2007: Data Labels
2007: Sort Groups of Cells
2007: I want glitter images to insert
2007: Trouble printing message 'print to file'
2007: CTRL D
2007: How to count interstitial blank cells?
2007: How do I sort by EBCDIC sequence in EXCEL?
2007: Values to a folder name on desktop
2007: Lists and sub lists
2007: A function that looks for a value on a sheet on unknown column or row
2007: Inserting lists from a drop down menu????
2007: Default Information Showing Up
2007: Find and replace
2007: average with mulitple ciriteria
2007: NUMBER WATERMARKS
2007: Multiple screen splits for same worksheet in Excel
2007: How do i insert of spacer rows between rows in large spreadsheets
2007: How do I get Excel to generate an ex-gaussian distribution?
2007: Files links
2007: Auto Fill Series when number ends in -1
2007: How to make quot;This workbook contains links to other data sourcesquot; appear?
2007: Multiple Variables in a Commission Structure...a tough one!!!
2007: VBA project is protected
2007: linked cells change to literals
2007: Some Macro Help Please
2007: sorting a list
2007: Excel
2007: Function for upper and lower control limits?
2007: 30 day planner template
2007: Excel 2000 Pivot Table Calculated Fields
2007: To add a name of label on several sheets.
2007: Adding a List of Members to a shared workspace
2007: LIST DATES IN MONTH ORDER
2007: How can I display two seperate stacked bars in a graph
2007: Average first 3 numbers in column e.g. 130 in 130/82
2007: I would like to view both worksheets in a file. Possilble? How?
2007: Pivottable to count non-zeros
2007: hOW DO i MAKE A COLUMN SLIDE ALONG WHEN I'M SCROLLNG SIDEWAYS
2007: Can I remove a hyperlink without removing the color of the cell?
2007: How to hide the outlook toolbar when opening an excel file
2007: AYUDAME A PAGAR MIS DEUDAS Y DE PASO RECIBE TAMBIEN DINERO.....
2007: Tab Key Expanded Cell Movement
2007: Excel User Conference
2007: average of several cells excluding the minimum
2007: Transferring data from MS Access to MS Excel
2007: How can I get a postal code in a cell
2007: Is it possible to apply conditional formating to a pivot chart?
2007: How do i get my data to transfer to another work sheet?
2007: Capitalization?
2007: receipts
2007: Excel suddenly requests the instal disk!
2007: How do I stop mouse from highlighting cells automatically
2007: restrict users

留言列表

站方公告

活動快報

【船井...

newdirect

船井生醫推出專門針對高度用眼族、輕熟齡者的葉黃素... 看更多活動好康

我的好友

熱門文章

文章分類

最新文章

最新留言

動態訂閱

文章精選

所有文章列表

文章搜尋

新聞交換(RSS)

誰來我家

參觀人氣

本日人氣：
累積人氣：

QR Code

qrcode

POWERED BY

(登入)