Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Hide formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions |