LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,091
Default Excel Number Conversions

Excel's standard column width is 8.43 characters, 64 pixels. You might see
something different if you increase your column width. Click on the column
separator bar at the right of the column header (B, for example) and drag to
the right.

Tryo
"Joel" wrote in message
...
I have a problem when using numbers in excel. I've created a record called
UPC for my item references and number are supposed to be viewed as this:
659078740069. I save the format in csv. and when I go to reopen to file
the
numbers that I've entered show as 6.59079E+11. I've changed the format of
the
number from General to Number, save, close and open and it displays
6.59079E+11 again I go on to stretch the record to see if it shows the
number correctly but they don't show. I change the format of the cell from
general to text and again it shows 6.59079E+11 its frustrating because I'm
uploading my csv files onto a online inventory management program called
netsuite and I need to be able to display these numbers correctly if
anyone
can help me PLEASE DO!!!!!



 
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
Maintaining Number Formats from Excel to CSV File Conversions laura1027 Excel Discussion (Misc queries) 6 June 6th 07 02:01 AM
Conversions dengel Excel Worksheet Functions 2 February 13th 07 09:56 PM
Odd number conversions??? Christian Excel Discussion (Misc queries) 3 March 15th 05 09:57 PM
Conversions Curious Excel Discussion (Misc queries) 1 February 21st 05 10:14 PM
Conversions ICMIII Excel Discussion (Misc queries) 2 February 21st 05 09:19 PM


All times are GMT +1. The time now is 12:44 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"