Thread: How can I put an apostrophy next to a number on my Excel workshee.
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Rabbit Rabbit is offline
external usenet poster
  
Posts: 5
Default How can I put an apostrophy next to a number on my Excel works
Gord, your answer was brilliant, thanks sooooooo much. Rabbit

"Gord Dibben" wrote:

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?


Reply With QuoteReply With Quote