Hi! It's my first time here. I need to develop a formula for the following example:

8100 <--This is what I input
8.10E+3 <-- an intermediate I'll need (pretty easy to convert to this format)
8103 <-- another intermediate (basically the . E and + need to go away)
81030 <-- if the E notation is "+" I need to add a 0 to the end of the string; if the E notation is "-" then I need to add a 1 to the string

In a nutshell, I'm trying to automatically generate 81030 from 8100. Does that make sense? Here's another example:

Input: 0.777
7.77E-1
7771
77711 <-- the number I need

The problem I'm having is that excel can't see the E notation as a character, as far as I know. Since it only sees it as a number I can't extract the notation and make it become a character. Any ideas? Thanks!!