Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to use GETFORMULA() in EXCEL 2003? | Excel Worksheet Functions | |||
array formulas and getformula UDF | Excel Worksheet Functions | |||
GetFormula function- Need help showing formulas only- | Excel Worksheet Functions |