Decimal place Help

Here's the problem

I need to be able to enter a number into with 5 decimal places into a cell labeled Resolution: 0.00001
Then i need certain other cells to have that same resolution

Please Help

Right click on cell, select 'Format Cells', select 'Number' Tab and choose either (number), (currency) or (scientific) and increase decimal places to 5.
Or have I misinterpreted what you want.

Steve

I didn't explain this very well, my bad

If i type in B1: 0.00001
and then I type in F7: 1.82
F7 will now read: 1.82000
If i Change B1 to: 0.001
F7 will now read 1.820

I basically need to do what you said, but type in the format in cell

Anybody have any ideas?

The closest I've come to what I think you are describing is to use the =TEXT(value,format) function. With the value 1.82 in F7 and the text string '0.00000' (make sure it enters as text, you don't want it to be the value 0) in B1, in F8 put the formula =TEXT(F7,$B$1) Then you can put whatever number format code you want into B1, and the output will be formatted using that format code.

Yeah, That doesnt Work, Because I need to be able to multiply the number that will be used for formatting