Thank you. The apostrophe seems to work, and does not actually end up
in the cell (like a space character would.)
I was going to ask "is this the official way to do it, or just a
hack?", but then I found the following MS KB articles:
- 'Text or number converted to unintended number format in Excel'
(
http://support.microsoft.com/kb/214233)
- 'How to prevent the automatic creation of hyperlinks'
(
http://support.microsoft.com/kb/291209)
Looks like the leading apostrophe is the way to keep Excel from doing
*anything* with the value. Good stuff!
If there are any caveats, I would love to hear them...
--
Steven Wazowski
------------------------------------------------------------------------
Steven Wazowski's Profile:
http://www.excelforum.com/member.php...o&userid=30199
View this thread:
http://www.excelforum.com/showthread...hreadid=498823