| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Symbols inside cells
I want to put a symbol in a cell with a number, [+2] for example. However
when I do this Excel automatically removes it, [+2] becomes [2]. How can I get Excel to leave the cell, or others like it, alone? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Symbols inside cells
Hi,
Type a single quote first and then type what you need. For eg. type ='+2 which would appear as +2 Regards Govind. Jedi_Wcu4 wrote: I want to put a symbol in a cell with a number, [+2] for example. However when I do this Excel automatically removes it, [+2] becomes [2]. How can I get Excel to leave the cell, or others like it, alone? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Symbols inside cells
Precede your data with an apostrophe
-- Gary's Student "Jedi_Wcu4" wrote: I want to put a symbol in a cell with a number, [+2] for example. However when I do this Excel automatically removes it, [+2] becomes [2]. How can I get Excel to leave the cell, or others like it, alone? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
| Counting only active cells | Excel Discussion (Misc queries) | |||
| Fill cells from non-adjacent cells | Excel Discussion (Misc queries) | |||
| Help adding text values | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Linear Mode
