Is there a function or a formula that will create a timestamp in a cell
without it being updated when the spreadsheet is saved? Like a =NOW()
function that isn't updateable or can you make the =NOW() function where it
doesn't update?
Is there a function or a formula that will create a timestamp in a cell
without it being updated when the spreadsheet is saved? Like a =NOW()
function that isn't updateable or can you make the =NOW() function where it
doesn't update?
>From Excel Help -
Insert the current date and time in a cell
Insert a static date or time
Current date Select a cell and press CTRL+;
Current time Select a cell and press CTRL+SHIFT+;
Current date and time Select a cell and press CTRL+; then SPACE then
CTRL+SHIFT+;
Gary
See
http://www.mcgimpsey.com/excel/timestamp.html
In article <9C68D959-13E3-4CAD-9693-EB895B4B96F8@microsoft.com>,
Guard 823 <Guard 823@discussions.microsoft.com> wrote:
> Is there a function or a formula that will create a timestamp in a cell
> without it being updated when the spreadsheet is saved? Like a =NOW()
> function that isn't updateable or can you make the =NOW() function where it
> doesn't update?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks