I have an account field that may have account numbers that have leading 0's. The field is 086.acct for example. When I use a find and replace for .acct to blank or to " " as text format the result is always 86 stored as a number. How do I remove the extra text without losing the leading 0 and text format?
Last edited by cheswick; 05-23-2018 at 04:08 PM.
Set the NumberFormat of the cell to show three digits.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
I would suggest making sure you format the cells to TEXT 1st
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks