Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I've imported a series of numbers and when I save it in csv format, it
changes the numbers to the scientific format unless it's under 10 digits. I've tried converting to text, multipling by 1, but nothing seems to keep it formatted as a number? Each time it looks like it will work, I save it and reopen it, only to find the numbers converted to scientific format again. I'm completely confused as to why it won't store it as a general number if over ten digits? -- JR Wireless |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
Format a cell with numbers and user defined text | Excel Discussion (Misc queries) | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
Converting numbers to date format from csv files | Excel Discussion (Misc queries) | |||
How do i change numbers in text format to number format? | New Users to Excel |