Fractions showing up as decimals

[Guest]

I have a spreadsheet with columns of fractions, but when you select a cell
the function bar shows a decimal instead and when you save as text file it
saves as decimal instead of fraction. Could someone please tell me how to
make it show as a fraction in the function bar? I have tried formatting the
cell as fraction and it does not work that way

Dani

 

[Gord Dibben]

Dani

Formatting a number as a fraction like 1/2 or 1/5 is strictly for appearance on
the sheet.

The underlying value is still .5 or .2

The formula bar shows that number and when you save as text file, that is the
number that gets saved, not the fraction you see on the sheet.

Make a copy of the workbook then............

You could add columns and type in the fractions by preceding with an apostrophe.

'1/2 '1/5

Delete the original columns with the numbers and save this version as the text
file.


Gord Dibben MS Excel MVP