Automatically add " sign

[Robyn Bellanger]

Is there a way to automatically add a symbol to a number when typed in
without having to type it? Example: I have a large spreadsheet of numbers
I need to enter, which all represent "inches". I would like to be able to
type in 99 and hit enter and have it show automatically as 99".

Hope this makes sense and thanks in advance for your help!

 

[Frank Kabel]

Hi
you could use a custom format such as
00"''"

Note the different type of apostrophes:
" ' " '
(with spaces between them)

 

[Guest]

Try using a Custom Number Format for the cells that need the symbol.
this one seems to work:
#\"

Note: if you have manually typed " into the cells, you'll need to delete it.
Then, Select the cells
Go to Format | Cells. Choose Custom
Type: #\" into the box.

tj

 

[David McRitchie]

and in using a Custom Format you still have a number
that you can treat arithmetically.