LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default One-time NOW() function

When you enter the NOW() function in a cell, the current date/time info gets
put nito the cell. What I want is a one-time functioning of NOW() so that
the date and time that I enter NOW() into the cell remains the same. As
everyone knows, NOW() will get recalculated to the present each time
recalculation for that worksheet takes place. Thanks for any help anyone can
be.
--
BigD
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
why does the vlookup function not work using time? vicky Excel Worksheet Functions 1 September 27th 06 08:18 PM
Adding Time Function Joe Excel Worksheet Functions 4 September 27th 06 04:27 PM
time sheet drop down lists Steve Excel Discussion (Misc queries) 12 March 18th 06 10:30 PM
=NOW() Time Function. I want this to be live! Gareth Evans Excel Worksheet Functions 7 August 11th 05 10:11 AM
clock Wildman Excel Worksheet Functions 2 April 26th 05 10:31 AM


All times are GMT +1. The time now is 05:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"