Automatically add " sign

R

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!
 
F

Frank Kabel

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

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

tjtjjtjt

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
 
D

David McRitchie

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