Get instant live expert help on I need help with vba format number

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I need to format a number from 46 to 006046 BUT I can't use Custom. I have to format as "Special" or my legacy system will not read the number. How do I do this as a special number format?
Solved by B. Y. in 25 mins
vba code to apply formula for a number columns and dynamic number of rows and then copy paste only values over them
Solved by X. H. in 22 mins
Hello I have an equation in scientific notation... it is y= 6E-13(x)^3 - 1E-07(x)^2 + 0.0121(x) I need to be able to solve for x (x is a variable number in my vba code) I need to figure out how to format this equation to be able to obtain a y value using x(variable number in my code)
Solved by G. A. in 18 mins
Can you help me to count the number of male & female per cluster, I think this will need VBA.
Solved by O. E. in 18 mins
need a macro/vba to combine specific sheets with the same name and format on separate workbooks to a "master" workbook/sheet. the master should only have the headings once
Solved by C. J. in 18 mins