This may be more work than you want to go to, but you could create the result
using TEXT, then convert "E" to "e" using SUBSTITUTE.

--
Regards,
Fred


"Cory" wrote in message
...
Excel 2000 allows scientific notation to use either upper or lower case "e"
in scientific notation (e.g. the format "0.0e+0" is accepted). However,
Excel 2003 does not seem to allow the use of lower case "e" in either the
text formatting or the TEXT function. Does anyone know why this was changed?
Is there any way to get Excel 2003 to accept the lower case "e"?

Thanks,
Cory