Calador --

Just do the reverse of what's been described. Format the cells to number
(perhaps 0 decimals with a comma separator). Then, when you type in 3E3, it
shows up as 3,000.

HTH

"Calador" wrote:

hmm my point is not to type 3E3 and show it as that. i would like to type out
3E3 and for it to show 3000. How do i go by that? instead of formatiing cell
to show it as general or numerical and not scientific