creating a measurement conversion table

All calculations are simply multiply or divide by 100 or 1000s so this SHOULD be easy.
I need help creating a matrix where you can enter ANY number into ANY field...and the surrounding fields would calculate/convert properly.

As you say, the calculations themselves are simple -- simply moving the decimal point around. What is difficult is that you are asking each cell to be both input and processing/output. In my experience, this is difficult in a spreadsheet. It will require a VBA procedure likely associated with an event (change and/or calculate).

If this were my spreadsheet, I would go with a different approach. Something like this:
1) Designate two cells as input cells -- one cell for the value and one for the prefix (k, m, c, etc.)
2) I would have a lookup table somewhere where I could lookup the "factor" for the prefix entered by the user.

prefix,factor
M,1E6
k,1E3
m,1E-3
etc.

Use one of the lookup functions http://office.microsoft.com/en-us/ex...670.aspx?CTT=1 to return the factor to convert the input value to the base unit
3) Then your row/table will just need functions to convert the base unit to each derivative unit

value,unit
=invalue*lookupfactor,"base unit"
=A$5*1E6,u 'you could use your lookup table here, too.
=A$5*1E3,m
etc.

Thanks guys!
I'll try the lookup/factor approach first. I want them to be able to enter any field/measurement they have instead of defaulting them to use one or 2 specific ones.
I'll post back on how it goes.