For an assignment, I'm to enter the text:
Swimming
Beginning (5)
Intermediate (5)
Advanced (5)
The number 5 in parentheses designates total times for the class.
When I try to insert (5) in the cell and hit quot;Enterquot;, what it shows is (504))
Even when I've tried to format the cell, it does not allow me to enter (5)!
Any help would be appreciated.
procede it with an apostrophe
'(5)
the ' will not show
sorry if this is a repost, my computer is messing up.
quot;jinxMNquot; wrote:
gt; For an assignment, I'm to enter the text:
gt;
gt; Swimming
gt; Beginning (5)
gt; Intermediate (5)
gt; Advanced (5)
gt;
gt; The number 5 in parentheses designates total times for the class.
gt;
gt; When I try to insert (5) in the cell and hit quot;Enterquot;, what it shows is (504))
gt;
gt; Even when I've tried to format the cell, it does not allow me to enter (5)!
gt;
gt; Any help would be appreciated.
Try using the text indicatior ' before you type in (5)
For example: '(5)
Good Luck!quot;jinxMNquot; wrote:
gt; For an assignment, I'm to enter the text:
gt;
gt; Swimming
gt; Beginning (5)
gt; Intermediate (5)
gt; Advanced (5)
gt;
gt; The number 5 in parentheses designates total times for the class.
gt;
gt; When I try to insert (5) in the cell and hit quot;Enterquot;, what it shows is (504))
gt;
gt; Even when I've tried to format the cell, it does not allow me to enter (5)!
gt;
gt; Any help would be appreciated.
Just in case the other solutions don't work, try checking autocorrect
(tools/autocorrect) to make sure that someone hasn't told Office to change
(5) to (504). I tried entering (5) in Excel and just got a -5.
--
Kevin Vaughnquot;jinxMNquot; wrote:
gt; For an assignment, I'm to enter the text:
gt;
gt; Swimming
gt; Beginning (5)
gt; Intermediate (5)
gt; Advanced (5)
gt;
gt; The number 5 in parentheses designates total times for the class.
gt;
gt; When I try to insert (5) in the cell and hit quot;Enterquot;, what it shows is (504))
gt;
gt; Even when I've tried to format the cell, it does not allow me to enter (5)!
gt;
gt; Any help would be appreciated.
In addition to other suggestions, you can also format the cells as
Text.
Format|Cells...|Number tab
HTH
Kostis Vezerides
- Oct 05 Fri 2007 20:40
How do I enter (5) in Excel and read as text?
close
全站熱搜
留言列表
發表留言