Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enter (5) in Excel and read as text?
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 "Enter", 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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enter (5) in Excel and read as text?
procede it with an apostrophe
'(5) the ' will not show sorry if this is a repost, my computer is messing up. "jinxMN" wrote: 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 "Enter", 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enter (5) in Excel and read as text?
Try using the text indicatior ' before you type in (5)
For example: '(5) Good Luck! "jinxMN" wrote: 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 "Enter", 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enter (5) in Excel and read as text?
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 Vaughn "jinxMN" wrote: 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 "Enter", 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enter (5) in Excel and read as text?
In addition to other suggestions, you can also format the cells as
Text. Format|Cells...|Number tab HTH Kostis Vezerides |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Read from Barcode Reader in Excel and Auto hit enter | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
numbers and text in Excel to read as text keeping the leading zer. | Excel Discussion (Misc queries) |