Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Discussion (Misc queries) > How can I lock a date that has been established by the 'today ()'.
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
ENT3041
 
Posts: n/a
Default How can I lock a date that has been established by the 'today ()'.

Reply With QuoteReply With Quote
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default


Reply With QuoteReply With Quote
  #3   Report Post  
RagDyer
 
Posts: n/a
Default

"Peo Sjoblom" wrote in message
...

Reply With QuoteReply With Quote
  #4   Report Post  
Gord Dibben
 
Posts: n/a
Default
CopyPaste SpecialValuesOKEsc.

OR enter the date using CRTL + ;(semi-colon)

Gord Dibben Excel MVP

On Mon, 3 Jan 2005 13:51:12 -0800, "ENT3041"
wrote:


Reply With QuoteReply With Quote
  #5   Report Post  
Gord Dibben
 
Posts: n/a
Default
LOL

Gord

On Mon, 3 Jan 2005 14:43:01 -0800, "Peo Sjoblom"
wrote:



Reply With QuoteReply With Quote
  #6   Report Post  
Dave Peterson
 
Posts: n/a
Default

Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

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
Date updates from worksheet to chart & changes date to a date series! Help!! Jayjg Charts and Charting in Excel 2 January 22nd 05 03:00 PM
Today() or Date() function help julisimo Excel Discussion (Misc queries) 8 January 3rd 05 04:19 PM
Date Formula Robyn Bellanger Excel Discussion (Misc queries) 2 December 17th 04 07:25 PM
Date formula Robyn Bellanger Excel Discussion (Misc queries) 2 December 16th 04 12:41 AM
Problem with Date format from VBA code twig Excel Discussion (Misc queries) 3 December 7th 04 06:01 PM


All times are GMT +1. The time now is 12:20 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"

 

Contact Us ExcelBanter forum home Privacy Statement