I have a formula that calculates a date/time in a cell outside of my pivot table in a jet report. When I refresh, the formatting gets wiped on that cell. Anyone know how to keep that from happening?
Date
Votes
2 comments
-
Jet Reports Historic Posts I figured it out using a nested NP function:
=NP("Format",NP("Eval","=Now()"),"mm/dd/yyyy H:MM AM/PM")
I still don't understand why it's stripping my other excel formulae from the spreadsheet, as well as my text. What's really odd is it leaves some of my text, but the rest is being cleared. -
Jet Reports Historic Posts Ah, maybe now I understand. If I add text in Design Mode, it stays.
Please sign in to leave a comment.