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. |
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) |