Original Fractions in Spreadsheet Don't Convert to Fractions

[dinokovac93]

Hi guys,

I'm having this weird issue in my spreadsheet. I have columns populated with fractions but in excel they are not yet selected as fractions (They are "general"). When I select them and change the data type to fraction, it says its a fraction but there is no change. When I individually click and go into the cell and then press "enter" it updates (reduces down). How do I make all the cells update instead of manually do it for each?

 

[dinokovac93]

Not too sure what the problem was but I fixed it using this code

[FONT=&quot]Dim rng As RangeSet rng = Application.SelectionDim cell As Range For Each cell In rng cell.Formula = cell.Formula Next[/FONT]