I have recorded this in Excel 2003.
I Think it will also work in earlier versions.
Sub AllCellsAsText()
'
' AllCellsAsText Macro
' Macro recorded 29-1-2004 by Wouter Magré
'
'
Cells.Select
Selection.NumberFormat = "@"
End Sub
It can changed into the next line of code.
So will de complet shot NOT be selected
Cells.NumberFormat = "@
--
Message posted from
http://www.ExcelForum.com