| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I reformat fractions that are expressed in smaller font?
How do I reformat fractions that are expressed in a smaller font than the
remaining text in an Excel cell? Reducer FTG x C 1-½" x ¾", we would like it to read 1-1/2" x 3/4" for import into our accounting software package. Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I reformat fractions that are expressed in smaller font?
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,CHAR(190),"3/4"),CHAR(189),"1/2"),CHAR(188),"1/4")
-- David Biddulph "cwalton" wrote in message ... How do I reformat fractions that are expressed in a smaller font than the remaining text in an Excel cell? Reducer FTG x C 1-½" x ¾", we would like it to read 1-1/2" x 3/4" for import into our accounting software package. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why is the font printing smaller than it should? | Excel Worksheet Functions | |||
| Font size smaller and bigger in a formula | Excel Worksheet Functions | |||
| Ratios expressed in excel? i.e. 3:7 | Excel Worksheet Functions | |||
| My tabs' font size is smaller - how do I restore default size? | Excel Discussion (Misc queries) | |||
| Smaller Font Sizes ? | Excel Discussion (Misc queries) | |||
Linear Mode
