Pre-format the cells to Number with no DP

Enter 3e3 and see what comes up.

Excel 2003 returns 3000


Gord Dibben MS Excel MVP

On Thu, 29 Nov 2007 14:14:01 -0800, 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