View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)[_520_] Rick Rothstein \(MVP - VB\)[_520_] is offline
external usenet poster
 
Posts: 1
Default How to add an inverted comma in a cell?

A leading "inverted comma" (also known as an apostrophe) is used to make
what follows it text... so, use two of them at the beginning instead of
one...

''Xpress'

Rick


"Newbie" wrote in message
...
I am trying to type 'Xpress' into a cell. the first inverted comma keeps
disppearing. How do I solve this? Thanks!