I am trying to create a Macro to convert a number to text. I have the following code:
Sub Convert2Text()
For Each Cell In Selection.Cells
OldNF$ = Cell.NumberFormat
Cell.NumberFormat = "@"
Cell.Value = Application.Text(Cell.Value, OldNF$)
Next
End Sub
This works great until I get to a cell with a blank value, then it returns a 0. I need it to leave the cell blank. I am very new at scripting but I was thinking some type of a condition loop applied to the above logic might work. Any help would be great. Thanks.
Bookmarks