Exporting formula to Excel

[halabis]

I am working on converting an excel spreadsheet into an access database, and one of the fields in the spreadhseet does an MROUND on another. I need to be able to export an MROUND function to excel so that other users can simply hit a button and have their output spreadsheet formatted properly.




The solution i have hit on is to have access manipulate the date until it is in the proper format for an excel MROUND.

My Access query performs the following formula

HoursMissed: "=mround((" & [MinutesMissed] & "/60),.25)"

and returns a field in the table that looks like this in the datasheet view

=mround((14/60),.25)


Now, my thought is that when I export this to excel it will retain the exact text and thus will be a formula the excel can then use. However that is not what happens. The output on excel looks is just ".23" I find this incredibly odd. Intuitively I would think that it would be "=mround((14/60),.25)" My first thought was that during the export process excel is executing the formula instead of simply copying over the table's value. However that can't be the case as the excel output for the formula is ".2333333333" etc. Access cant be executing the formula as mround means nothing to access. What in the world is going on here?

[June7]

Since the export procedure is definitely somehow evaluating the expression, have to accept that reality.

AFAIK, if you want to set a cell to a formula, requires code. Example:

For i = 1 To 167
    For intCCount = 2 To 7
        Cells(intRCount, intCCount + 1).Select
        ActiveCell = "=IF(Results!$" & strCol & "$" & intRow & "=0, " & Chr(34) & Chr(34) & ", Results!$" & strCol & "$" & intRow & ")"
        intRow = intRow + 1
    Next intCCount
    intRCount = intRCount + 40
    intCCount = 3
    Cells(intRCount, intCCount).Select
Next i

Why would you want to pass a formula that has constants and no dynamic cell referencing? Why not just the calculated value?