Listed below is a section of the macro I'm trying to create. This section creates a Forms Button assigned with the macro called "Import". The problem I'm having is that the default text, in this case "Button 17", is displayed on the button after the macro runs. I can't get...
I have numbers similar to what is listed below that are being downloaded into Excel. I need to take the number and remove the "-" from it, but leave the rest of the number in the same cell.
Example:
These are some of the numbers being downloaded and imported into Excel:
A8001-O-C...
When I begin typing a recipient's address in the "To" field, Outlook will bring up multiple "suggested" email addresses for me to choose from so I don't have to type in a complete address. In some cases, these addresses are spelled wrong. I can't seem to locate where they are...
When I begin typing a recipient's address in the "To" field, Outlook will bring up multiple "suggested" email addresses for me to choose from so I don't have to type in a complete address. In some cases, these addresses are spelled wrong. I can't seem to locate where they are...
Thanks to both of you for the help...this gets me exactly what I'm wanting. I think I was overthinking the problem a little bit.
I do have one follow up question for Skip though. If I follow you correctly, you are saying that the formatting is only for the sake of the display. In what...
I'm importing dollar amounts from an ASCII file and need them to format a certain way.
Example:
This is how the numbers look after I import them into my spreadsheet.
1.23
12.23
123.45
1234.56
This is how I need the same numbers to look after I apply the proper formatting:
000000123...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.