| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with leading Zeros when running Macro
Having a problem with formatting leading zeros. I am running a macro
that calculates RAND() and RANK then returns a 2 digit number in Col Y and another 2 digit in Col Z with whichever 2 digit number is ranked 1 then I do a Sum with this formula =LARGE((Z29:Z84),1) then try to join both 2 digit numbers with this formula =LARGE((Y85:Y86),1)&LARGE((Z85:Z86),1) my macro calculates and then copies and pastes results to Col A 25 times but I can not get leading zeros to show no matter how I try to format col Y or col Z or col A Can anyone help me with this. It is driving me nuts!!!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| leading zeros in text format | Excel Discussion (Misc queries) | |||
| Concatenation with leading zeros | Excel Worksheet Functions | |||
| CSV File - Leading Zeros | Excel Discussion (Misc queries) | |||
| Leading Zeros with a twist. | Excel Discussion (Misc queries) | |||
| zero supress leading zeros when chg format from text to number | Excel Worksheet Functions | |||
Threaded Mode
