Odd Question: Data to Text

[Guest]

A user has a huge spreadsheet. One column has been converted from data to
text.

We need every single cell to have the green error flag in the upper left
corner. This is needed to merge this spread with another program.

Is there some other way to accomplish this other than double clicking on and
outside of every cell? I'm talking about thousands of cells here....

Thank you!

 

[Gord Dibben]

I am confused.

I assume by "data" you mean "numbers".

You say the column has been converted to text.

How did you accomplish the conversion?

Error flag or no error flag is showing currently on the cells in this column?

You want an error flag in each cell?

Is Error-checking enabled in Tools>Options>Error-checking?

Are the appropriate checkboxes enabled?

Do you want a macro to add an apostrophe to every cell?

Sub Add_Text_Left()
Dim cell As Range
Dim thisrng As Range
Set thisrng = ActiveSheet.UsedRange
For Each cell In thisrng
cell.Value = "'" & cell.Value
Next
End Sub


Gord Dibben MS Excel MVP