Thread: Custom Zeros
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Totoshi Totoshi is offline
external usenet poster
 
Posts: 3
Default Custom Zeros

Hi,


i have a issue in excel 2003 VBA, how can i costumize the decimal
places for a range of cells with the number format from other cell.
For example :

in Column A i have 1.21 ; 1.56 ; 1.789 ; 1.9899 ; 0.1

and in cell B1 i have the number 0.001 .

So i want to format by a function Column A so the contents in cell
appears like this :

1.210 ; 1.560 ; 1.789 ; 1.990 ; 0,100 .

Can anyone help me with this ?

Thank you , Cheers