Excel VBA Format Number/Date

How to format number using VBA?
How to format date and time using VBA?

01:07 Fixed number of digits (Put "0" in front of number whenever is needed")
02:38 Fixed number of decimal places
04:00 Add thousands separator, comma ( , ) to numbers
05:15 Display negative numbers in brackets
06:55 Convert decimal numbers to fractions
08:45 Convert decimal number to percentage
09:30 Formatting a date