Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I put an apostrophy next to a number on my Excel workshee.
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I put an apostrophy next to a number on my Excel workshee.
enter two apostrophes rather than one.
-- Gary's Student "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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I put an apostrophy next to a number on my Excel workshee.
"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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I put an apostrophy next to a number on my Excel works
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 On Sat, 26 Aug 2006 12:06:01 -0700, Rabbit wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
formatting number value to text value in excel | Excel Worksheet Functions | |||
Excel random number | Excel Discussion (Misc queries) | |||
Excel 2003 random number generator | Excel Discussion (Misc queries) | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) |