suppress date function from updating after emailing workbook

WGGMKG

New Member
Joined
Sep 7, 2006
Messages
11
in my workbook, i have the date listed in one cell, using =today(). when i email the workbook to another person the date gets updated when they open the workbook.
is there anyway to suppress the date function and only leave the function result visible? without manually entering the date?
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Watch MrExcel Video

Forum statistics

Threads
1,109,489
Messages
5,529,168
Members
409,853
Latest member
Amy Gassett
Top