How can I put an apostrophy next to a number on my Excel workshee.

R

Rabbit

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?
 
G

Gord Dibben

Type two of them.

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


Gord Dibben MS Excel MVP
 
R

Rabbit

Rabbit said:
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?
Click to expand...
 
G

Gord Dibben

Rabbit

An explanation for my brilliance.

Excel treats one apostrophe as a signal that the data will be in Text format.

The one apostrophe therefore does not show in the cell.

One for text format, two to show an apostrophe in the cell.


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need some PWA help 0
How do I add an apostrophy to a range of existing cells? 3
how to carry forward a total from one page to another 3
how can I clear an apostrophy in front of number in excel 4
How to format data in excel into a booklet, word or publisher? 1
Sign up page in Frontpage 2003 3
Formula to validate characters within a string of data in aparticular cell 1
how do I put in a sequence number on yearly basis? 1

Top