Hello All,
Im having difficult with scientific notation on a text file import & am hoping its a quick fix...

On my spreadsheet, a cell displays "57774126419580100000000000000"
In the formula bar it says "5.7741264195801E+28"

When i use the LEFT() function. It returns 5.777 instead of 57777. How can i get this to return the 57777?

Ive tried formatting as number, text, apostophe's, even formatting a cell before pasting the number into it (i read that is a trick one time).
I also converted it during the 'text-to-columns', which worked on the surface, but then my formulas shows in the cell without calculating.

Regardless, i hope this isnt a problem with Excel, and it seems so minor to waste time on so im here for the experts! Any help appreciated, thank you!