D
Dave F
I have the following code as a UDF which allows you to display the formula
for a referenced cell:
Function GetFormula(Cell As Range) As String
GetFormula = Cell.Formula
End Function
So, if A1 has as its formula =2+3, and I enter into B1 =getformula(A1), =2+3
is shown.
All well and good.
However, I have a number of cells formatted as times (8:30AM, etc.) and,
when I use =getformula(cell) on them, strange numbers return: .354166666...
Ideas? Does this have to do with 8:30AM being 35.4% of a complete day?
for a referenced cell:
Function GetFormula(Cell As Range) As String
GetFormula = Cell.Formula
End Function
So, if A1 has as its formula =2+3, and I enter into B1 =getformula(A1), =2+3
is shown.
All well and good.
However, I have a number of cells formatted as times (8:30AM, etc.) and,
when I use =getformula(cell) on them, strange numbers return: .354166666...
Ideas? Does this have to do with 8:30AM being 35.4% of a complete day?