Posts by skypork

  • Macro to F2 F9 Enter then Repeat

    Is there a macro which will change the field to text before this is executed? I tried to change after below code has been excuted it do not recover that zero
    With Range("C1:C1800") .Formula = .Value End With

  • Macro to F2 F9 Enter then Repeat

    Hi,


    With Range("C1:C1800") .Formula = .Value End With how can i retain my leading 0 ? eg. 04564 = 4564 but i want it to reflect 04564 but at the same time 55667788 = 55667788 i also want to retain this is there a way to balance both of them ? i tried .text but it do not work. Really appreciate if someone can help Thank you