1. clear the cell ( will get rid of any hidden apostrophies)
2. format as general
3. then re-type the formula ( do not paste it in )

--
Gary''s Student


"schuldies21" wrote:

I am trying to get results for a simple =(A2-INT(A2))*24 but this formula is
the only thing in the desired cell. I tried reformatting cell to general,
number, you name it. Having same problem with concantenate function.
Formula stays in cell, no results. Any help?