Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Maintaining Number Formats from Excel to CSV File Conversions | Excel Discussion (Misc queries) | |||
Conversions | Excel Worksheet Functions | |||
Odd number conversions??? | Excel Discussion (Misc queries) | |||
Conversions | Excel Discussion (Misc queries) | |||
Conversions | Excel Discussion (Misc queries) |