Page 89 - JoFA_Jan_Apr23

pulls the day of the date that is entered in cell
B2, as is; inserts a hyphen; pulls the month from
A2 and converts it to a Roman numeral; inserts
another hyphen; and finally pulls the year from
C2, as is. Drag this formula down for all dates.
The screenshot at the bottom of the previous page
shows the final date results.
You can use these same concepts to convert dates
using Arabic numerals to dates using Roman nu-
merals in other ways as well. For example, you may
want to convert the dates using Arabic numerals to
all Roman numerals. You would need to first dissect
the dates using Text to Columns as described above.
In cell E2, the formula that should be entered is
=ROMAN(B2)&”-”&ROMAN(A2)&”-”&ROMAN(C2).
Drag this formula down for all dates. The screenshot
at right shows the final date results.
— By Kelly L. Williams, CPA, Ph.D.

MICROSOFT EXCEL

Update AutoRecover setting in Microsoft Excel

Q. I have lost A. By default, AutoRecover is set to save every 10 AutoRecover is separate from AutoSave, which
some or all of minutes. I know that I don’t like redoing my work is available only when a file is saved to OneDrive
my work a few even from 10 minutes ago, so I have my AutoRe- or SharePoint in Microsoft 365 and you have a
times in Excel. I cover set to save every minute. To do this, click File Microsoft 365 subscription.
can recover most on the Ribbon, choose Options, then Save. Toward You can access a video demonstration of updat-
of it because of the top of the Excel Options window, change the ing AutoRecover settings in Excel with the online
AutoRecover, “10” to the right of Save AutoRecover informa- version of this article at journalofaccountancy.com.
but quite a bit of tion every to a “1.” Click OK. See the screenshot — By Kelly L. Williams, CPA, Ph.D. ■
it is sometimes below for the Excel Options window.
missing. Is
there a way to
AutoRecover
closer to real
time?

About the author Submit a question
Kelly L. Williams, CPA, Ph.D., MBA, is an associate professor Do you have technology questions for this column? Or, after
of accounting at the Jones College of Business at Middle reading an answer, do you have a better solution? Send them
Tennessee State University. to jofatech@aicpa.org. We regret being unable to individually
answer all submitted questions.

journalofaccountancy.com February 2023 | 39