• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Number with Text converts to Scientific Format

ChaCha90

New Member
I have a number that contains one letter i.e. 10113E6. When I go to input it into Excel it converts to a 'Scientific' format i.e. '1.01E+10' and if I try to select the 'General' format it changes to '10113000000'.

How can I keep it in the same format '10113E6' in Excel.

NumberScientificGeneral
10113E0
1.01E+04​
00010113​
10113E1
1.01E+05​
00101130​
10113E2
1.01E+06​
01011300​
10113E3
1.01E+07​
10113000​
10113E4
1.01E+08​
101130000​
10113E5
1.01E+09​
1011300000​
10113E6
1.01E+10​
10113000000​
 
Thank you @ Fluff13. That works if I input it manually one by one but what if the program exports it as a .csv spreadsheet that contains over 100 numbers that just automatically converts the numbers to the 'Scientific' format.
 
In that case you will need to import the csv using the import text wizard & set the relevant columns to import as text.
 
Back
Top