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?
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:
gt; I want to put a symbol in a cell with a number, [ 2] for example. However
gt; when I do this Excel automatically removes it, [ 2] becomes [2]. How can I
gt; get Excel to leave the cell, or others like it, alone?
Precede your data with an apostrophe
--
Gary's Studentquot;Jedi_Wcu4quot; wrote:
gt; I want to put a symbol in a cell with a number, [ 2] for example. However
gt; when I do this Excel automatically removes it, [ 2] becomes [2]. How can I
gt; get Excel to leave the cell, or others like it, alone?
- Dec 18 Thu 2008 20:47
Symbols inside cells
close
全站熱搜
留言列表
發表留言
留言列表

