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.
How can I keep it in the same format '10113E6' in Excel.
Number | Scientific | General |
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 |