How to change Format of a Cell to Text using VBA

by

To answer your direct question, it is:

Range("A1").NumberFormat = "@"

Or

Cells(1,1).NumberFormat = "@"

However, I suggest changing the format to what you actually want displayed. This allows you to retain the data type in the cell and easily use cell formulas to manipulate the data.

More Related Contents:

  1. Excel Number Separation [closed]
  2. excel vba compare & copy worksheets from 2 excel files
  3. VBA Stuck after certain loop
  4. How to avoid using Select in Excel VBA
  5. Is the . in .Range necessary when defined by .Cells?
  6. How to return a result from a VBA function
  7. Cycle through sub-folders and files in a user-specified root directory [duplicate]
  8. Convert Text to Date?
  9. Loop through each cell in a range of cells when given a Range object
  10. Checking for #N/A in Excel cell from VBA code
  11. Non-web SQL Injection
  12. Error: “Could Not Find Installable ISAM”
  13. Properly Handling Errors in VBA (Excel)
  14. Password hash function for Excel VBA
  15. Is there a way to slow down a Web Scraper so it will pick up the code?
  16. Create a folder and sub folder in Excel VBA
  17. Aggregate, Collate and Transpose rows into columns
  18. One-dimensional array from Excel Range
  19. Select method of Range class failed via VBA
  20. Renaming Files with Excel VBA
  21. Is there a way to import data from .csv to active excel sheet?
  22. Comparison of Dictionary, Collections and Arrays
  23. Break out of a While…Wend loop
  24. How to add events to dynamically created controls (buttons, listboxes) in Excel VBA userform
  25. How to make safe API Timers in VBA?
  26. Excel: the Incredible Shrinking and Expanding Controls [closed]
  27. How to send email to multiple recipients with addresses stored in Excel?
  28. Generate Word Documents (in Excel VBA) from a series of Document Templates
  29. Using Excel VBA Macro To Capture + Save Screenshot of Specific Area In Same File
  30. Type Mismatch in Loop to scan Outlook Messages [duplicate]

Leave a Comment