Automatically set number format

  • Thread starter Thread starter Norm2000
  • Start date Start date
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
 
Hi
only possible with vBA using an event procedure. Would this be a way
for you?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problem with round down 5
Inserting decimal 6
Stop XL from changing format? 1
decimal two places 5
Conditional formatting in Excel 2010 2
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
How do I prevent the cell from changing the number I enter? 2
format cells: divide by 100 4

Back
Top