Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
Hello,
Set column format to text first, then fill column with data, then data/text to columns and separate parts left from "/" from righter one (you may have to separate even a leading integer part first: for example "23 7/64"), finally divide values of these two columns in a helper column (multiply values by one to force text to number if necessary). HTH, Bernd |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with Array Formulas and ISNUMBER | Excel Worksheet Functions | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
How do I import fractions without data being converted to dates? | Excel Discussion (Misc queries) | |||
Paper Tray selection Problem, | Excel Discussion (Misc queries) |