View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default I need a dash, not a formula

Add an apostrophe (sp) to the beginning.

example:

'123456

HTH,
Paul

"SDP" wrote in message
...
Hello. I need to use dashes in my part numbers, but Excel thinks I want
to
use a formula. Can I turn this off somehow, so that I can just use dashes
as
dashes?
Thanks.