enter the capital letter e and hold down Shift+ letter e to complete the input.

enter the letter e in the number: set the cell format of column a as text, and then enter "123E1" to enter the number+capital letter e.

after entering the single quotation mark, enter the number +E letter:' 123E1.