Decimal place Help

**cadk73** · 02-14-2012, 07:06 PM

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

**steve troughton** · 02-14-2012, 07:32 PM

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

**cadk73** · 02-14-2012, 07:41 PM

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

**cadk73** · 02-14-2012, 07:47 PM

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

**cadk73** · 02-16-2012, 01:57 PM

Anybody have any ideas?

**Paul** · 02-16-2012, 02:28 PM

Do you have some kind of Worksheet_Change event running that re-formats cells when you enter data? I can understand if you typed .00001 into B1 and then 1.82 into B2 and it changed formatting to match the cell above it, but not from B1 to F7. I can't even get that to happen.

Are all of your cells formatted as 5 decimal places? Or are they General until you enter data into them?

**MrShorty** · 02-16-2012, 04:25 PM

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.