i am a problem when i doing my coding about format a number
for normal number with 4 digit , i have idea which is
e.g: Dim a As double
a = 1/ 2946.33 ' its return is 0.00033940529
If i use format number function with 4digits, the answer is "0.0003"
but i need to the format number with 4 digit which is not included 0
Can i anyone tell me how to do?