Is there a way with VBA to convert custom formatting into actual text. I have some numbers that are formatted as fractions, but the value itself is still a decimal. Is there a way to convert it to a text string so that contents of the cell is actually a fraction.
Ex: With my formatting 21.25 displays as 21-1/4 but the value of the cell is still 21.25. I need the actual contents of the cell to be 21-1/4.
Hello chaddug,
Each cell on the worksheet has two properties: Value and Text. Value will display the number, date, etc, as a numeric value. Text will return what you see in the cell as a text string.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Have you looked at the TEXT function.
(The Value and Text that Leith is speaking of are VBA properties. I'm talking about the worksheet function TEXT)
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Okay, using that information I tried this as a test and I got an Object Required error. The cells in column E have the numbers formatted as fractions, I want the actual text string in column F.
Please Login or Register to view this content.
It can be easily done with formula
=TEXT(A1,"00-0/0")
Row\Col 21-1/4 123-3/4
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Keep in mind, that if you convet the value to text, you will not be able to use it in future calcs, without a potentially involved conversion back to numeric.
What is the need for the conversion?
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