i want vba code to convert number in column D to store as text
i want vba code to convert number in column D to store as text
Hi,
Do you really need VBA to do this when you could simply use
Formula:Please Login or Register to view this content.
(or however you want any decimal to look) in a helper column, then copy the helper column and paste back as values.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
i want vba code to store any number as text automatically when i just put data
Enter it with a leading '
You do understand that, once a number is converted to text, it cannot be directly used in a formula after that?
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
Public Sub Pedie()
Dim rng As Range
For Each rng In ActiveSheet.UsedRange
rng.Value = rng.Value
Next rng
End Sub
this code is to made it general but i want to make it as text
can any one help me with that
because i have atext box which filter item as i type number but it filter only number which store as text
so can you change how the filter works?it filter only number which store as text
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks