Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I feel like I'm a pretty experienced Excel user but I'm totally baffled by
this problem. I use software to print postage for my business and the log file is saved in ..csv format. It is often helpful for us to share the .csv files from other computers onto my machine. Whenever I open the file though, all of the tracking numbers show up as 9.10101E27 When I click on the cell, the function bar gives me a few more digits but not nearly all of them and not enough for me to actually track the package. I also tried opening a brand new worksheet and typing in a number 11111111 into the first cell. I increased the number one digit at a time until it automatically changed to 1.1111E11 (so, 12 digits seems to be the cutoff). I feel like I've tried everything including un-installing and re-installing Excel but I cannot figure out how to get the numbers to display completely with every digit showing. This does not seem to be a "format, cells" issue because even the function bar is showing the number as stored incorrectly (normally, that value should be unchanged by the Format, Cells command) and the value only changes at 12 digits regardless of how large or small the column width is. I'm at my wits end. Please, any help would be GREATLY appreciated. Thank you, Lindsey Hathway |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
making a number be text | Excel Worksheet Functions | |||
how do i increase the number of digits displayed | Excel Discussion (Misc queries) | |||
How do I format cells to a specific number of digits? | Excel Discussion (Misc queries) | |||
Convert week number into calendar month? | Excel Worksheet Functions |