Hi Joshua,
Exactly what you asked for:
Use ##0.0E+0

More on cell formatting see first large table in
http://www.mvps.org/dmcritchie/excel...htm#cellformat
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Myrna Larson" wrote in message ...
Scientific notation is probably the closest you'll get.

On Sat, 22 Jan 2005 12:29:02 -0800, "Joshua Wong" <Joshua
wrote:

Hi,

I am wondering if there is a way to display numbers in engineering
notation?
ie. 3M if the number is 3e+6
or 5u if the number is 5e-6

Best regards,
Joshua.