| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Changing proper fractions to improper.
Hi.
I've looked through Excel's Help Index but can't find how to set Excel so that it displays proper fractions to improper. I've already set it so it show fractions and not decimals. E.g: I type in 7/3 but Excel formats it to read 1 2/3. I'd prefer to have this display as 7/3 . Thank-you. (I have Excel 97 but please tell me the solution for any version as I will have access to Excel XP soon.) |
|
#2
|
|||
|
|||
|
One way:
Format/Cells/Number/Custom ?/? In article , apersonoutthere wrote: Hi. I've looked through Excel's Help Index but can't find how to set Excel so that it displays proper fractions to improper. I've already set it so it show fractions and not decimals. E.g: I type in 7/3 but Excel formats it to read 1 2/3. I'd prefer to have this display as 7/3 . Thank-you. (I have Excel 97 but please tell me the solution for any version as I will have access to Excel XP soon.) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fractions turn into dates when pasting in excel 2003 | Excel Discussion (Misc queries) | |||
| Fractions to Decimals problem | Excel Discussion (Misc queries) | |||
| How do I keep excel 2002 from changing fractions to dates? | Excel Discussion (Misc queries) | |||
| Using PROPER for Columns, rows or ENTIRE spreadsheet | Excel Worksheet Functions | |||
| Changing Upper case to Proper Case | Excel Worksheet Functions | |||
Linear Mode
