how can I set up engineering notation in numbers '09?

I am taking some electronics courses in college and need to be able to use engineering notation ie: 1E-3, 9E6, etc. How can I best set this up in Numbers '09? All of my entries are automatically being formated as scientific notation (not multiples of 3) and the only other option I can find is just standard numbers. Thank you for your assistance.

Numbers '09-OTHER, Mac OS X (10.7.3)

Posted on Feb 15, 2012 7:48 PM

18 replies

eBomber

Level 1

0 points

Jul 9, 2013 7:34 AM in response to Jerrold Green1

In excel, with that format you get scientific notation, but in which the exponent is a multiple of three, which is what is intended (I think)

Yellowbox

Level 7

21,915 points

Jul 13, 2013 4:32 AM in response to Yellowbox

Nope. Needs more work.

Ian.

TYJaM0

Level 1

4 points

Aug 11, 2016 12:30 PM in response to TYJaM0

Nope. Needs more work. However, it does work in some instances.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

how can I set up engineering notation in numbers '09?

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up