Automatically set number format

N

Norm2000

I want to automatically set the number format (number of decimal places
of various cells based on a number I enter in another cell. Fo
example, if I enter 0.001 in cell A4, I want the number of decima
places for the other cells to change to 3.

Suggestions?

Thanks,
Nor
 
F

Frank Kabel

Hi
only possible with vBA using an event procedure. Would this be a way
for you?
 
Top