Hi zhj23,

Yes, there is a way to keep the percentage in text form without adding an apostrophe in the worksheet cell. Here's how you can do it in VBA:

1. Open the VBA editor by pressing Alt + F11.
2. Insert a new module by clicking on "Insert" from the menu bar and selecting "Module".
3. In the new module, create a function that takes a percentage value as input and returns the percentage as text with the percentage symbol ("%") at the end. Here's an example code:
   
   
   Code:

   Function ConvertToText(ByVal percentage As Double) As String
       ConvertToText = Format(percentage, "0.00%")
   End Function

4. Save the module and return to the worksheet.
5. In the cell where you want to display the percentage as text, enter the following formula:
   
   
   Code:

   =ConvertToText(0.2432)

   Replace "0.2432" with the cell reference that contains the percentage value you want to convert.
   
6. Press Enter to display the percentage as text with the percentage symbol at the end.
   
   That's it! This function will convert any percentage value to text with the percentage symbol at the end, without changing the original value. You can use this function in any cell in your worksheet to display percentages as text.