View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hayley Middleton Hayley Middleton is offline
external usenet poster
 
Posts: 1
Default Create a marcro that changes number of decimal places in a field according to specified criteria

Hi people, hope you can help me

I need a macro to do the following:

1. A1 contains a value - 2 (which determines the number of decimal places
2. A2 contains a value - 10
3. A3 gives the results - i.e A1 is number of decimal places for A2 therefore = 1.0

Can this be done

Thank you for your help

Hayley