View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How can I put an apostrophy next to a number on my Excel workshee.

Type two of them.

One will show in the cell....two will show in the formula bar.


Gord Dibben MS Excel MVP

On Fri, 25 Aug 2006 17:18:02 -0700, Rabbit
wrote:

I am doing a spreadsheet for our alumni reunion and need to indicate their
year of graduation. When I type '34 for example for the year 1934 the 34
appears but not the apostrophy. How can I correct that?