-
will do it but not for a cell in situ.
So otherwise a macro:
[vba]Sub blah()
For Each cll In Selection.Cells
cll.Value = """" & cll.Value & """"
Next cll
End Sub
[/vba]will do this for the currently selected range. If there are any formulae in the selection, they will be converted to values.
p54cal
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Reply With Quote