How do I turn a number "2.5" into a fraction "2 1/2" in a cell when the cell contains words, "His contract ends in 2.5 weeks" to "His contract ends in 2 1/2 weeks" other than obviously imputing it manually?
Forum Thread: Fractions with words
- Hot
- Active
-
Forum Thread:
How to Make a Simple Report Card Template in Excel
0
Replies
6 yrs ago -
Forum Thread:
How to Insert 'NESTED if' with Ease
0
Replies
6 yrs ago -
Forum Thread:
How to Memorise the Excel Formula Syntax
0
Replies
6 yrs ago -
Forum Thread:
How to Remove Line Breaks in Excel
0
Replies
6 yrs ago -
Forum Thread:
How to Create a Speedometer Chart or Gauge Chart in Excel
0
Replies
6 yrs ago -
Forum Thread:
How to Add Dependent Data Validations in Excel
0
Replies
6 yrs ago -
Forum Thread:
How to Create a Task Tracker in Excel
0
Replies
6 yrs ago -
Forum Thread:
OneNote 2010 document
0
Replies
8 yrs ago -
Forum Thread:
How to Turn Off Panning Hand
0
Replies
8 yrs ago -
Forum Thread:
While in a Spread Sheet, I Click on One Cell and It Will Auto Highlight Many. Why and How Do I Undo It?
0
Replies
8 yrs ago -
Mail Merge Software:
Hello.
0
Replies
8 yrs ago -
Forum Thread:
PPTX File Is Giving an Error and Can't Be Opened.
2
Replies
8 yrs ago -
Forum Thread:
How to Use Vlookup
0
Replies
8 yrs ago -
Forum Thread:
Need Some Help with an Inventory Formula. (Purchase Date)(Sold Date)(Number of Days Held). However, if the Inventory Is
0
Replies
8 yrs ago -
Forum Thread:
How to use AND, OR with the IF function
1
Replies
8 yrs ago -
Forum Thread:
How to Create a Personal Finance Spreadsheet
0
Replies
8 yrs ago -
Forum Thread:
How to Format a Chart Based on Another Chart Format
0
Replies
8 yrs ago -
Forum Thread:
Powerpoint Presentation Design
0
Replies
8 yrs ago -
Forum Thread:
How to Create Excel Based Interactive Awesome Histograms
0
Replies
8 yrs ago -
Forum Thread:
Why Aren't TRUE Excel Based Dashboards More Prevalent?
0
Replies
8 yrs ago
-
How To:
Generate random numbers (with decimals) in Excel
-
How To:
Create a Basic Attendance Sheet in Excel
-
How To:
Force text formulas to wrap with Excel's CHAR function
-
How To:
Create a Tangent Line with Excel
-
How To:
Conditionally format at every change in value in Excel
-
How To:
Value a stock with irregular dividend payments in Microsoft Excel
-
How To:
Clear data & cell contents in Excel using a macro
-
How To:
Calculate stock value based on the value of future dividend cash flow in Excel
-
How To:
Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
-
How To:
Use conditional formatting for a student grading report in Microsoft Excel
-
How To:
Generate a dynamic list from a table in MS Excel
-
How To:
Multiply column times row with Transpose in MS Excel
-
How To:
Calculate future & present value for multiple cash flows in Excel
-
How To:
Calculate salary based on work experience in MS Excel
-
How To:
Do matrix multiplication and inverse in MS Excel
-
How To:
Create a sudoku puzzle in Excel with array formulas
-
How To:
Create dynamic sub tables in Microsoft Excel
-
How To:
Score a Full Version of Microsoft Office for Only $10
-
How To:
Cross-check two lists for discrepancies in MS Excel
-
How To:
Build a conditional average calculation table in Exel
Be the First to Respond
Share Your Thoughts