Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom number format thousands and zeros as "-" | Excel Discussion (Misc queries) | |||
when i megre cells that begin with zeros , I lose the zeros | Excel Discussion (Misc queries) | |||
Essbase: Text zeros to number zeros | Excel Discussion (Misc queries) | |||
Custom sorting with Letters and Zeros | Excel Discussion (Misc queries) | |||
save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) |