PC Review


Reply
Thread Tools Rate Thread

How do I set a static date?

 
 
Shawn
Guest
Posts: n/a
 
      27th Aug 2008
In A1 I'm putting an Id number in and I would like to set a formula in B2 so
that a static date appears, can this be done?
 
Reply With Quote
 
 
 
 
Peo Sjoblom
Guest
Posts: n/a
 
      27th Aug 2008
http://www.mcgimpsey.com/excel/timestamp.html



--


Regards,


Peo Sjoblom




"Shawn" <(E-Mail Removed)> wrote in message
news:4A942DEF-E474-4EC3-8751-(E-Mail Removed)...
> In A1 I'm putting an Id number in and I would like to set a formula in B2
> so
> that a static date appears, can this be done?



 
Reply With Quote
 
T. Valko
Guest
Posts: n/a
 
      27th Aug 2008
See this:

http://www.mcgimpsey.com/excel/timestamp.html

--
Biff
Microsoft Excel MVP


"Shawn" <(E-Mail Removed)> wrote in message
news:4A942DEF-E474-4EC3-8751-(E-Mail Removed)...
> In A1 I'm putting an Id number in and I would like to set a formula in B2
> so
> that a static date appears, can this be done?



 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a
 
      27th Aug 2008
You could also hit the ctrl-; shortcut combination to get the date.

Shawn wrote:
>
> In A1 I'm putting an Id number in and I would like to set a formula in B2 so
> that a static date appears, can this be done?


--

Dave Peterson
 
Reply With Quote
 
Peo Sjoblom
Guest
Posts: n/a
 
      28th Aug 2008
It's in that link


--


Regards,


Peo Sjoblom



"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> You could also hit the ctrl-; shortcut combination to get the date.
>
> Shawn wrote:
>>
>> In A1 I'm putting an Id number in and I would like to set a formula in B2
>> so
>> that a static date appears, can this be done?

>
> --
>
> Dave Peterson



 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a
 
      28th Aug 2008
Yes, it is!

Peo Sjoblom wrote:
>
> It's in that link
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> "Dave Peterson" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > You could also hit the ctrl-; shortcut combination to get the date.
> >
> > Shawn wrote:
> >>
> >> In A1 I'm putting an Id number in and I would like to set a formula in B2
> >> so
> >> that a static date appears, can this be done?

> >
> > --
> >
> > Dave Peterson


--

Dave Peterson
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
DAYS360 where Start Date is Static and End Date is Latter of Two Dates Aimee Shaw Microsoft Excel Misc 1 28th Dec 2009 10:34 PM
Insert Current Date Save as Static Date patei Microsoft Word Document Management 1 10th Mar 2008 06:34 PM
static date created from form w/autoupdate date =?Utf-8?B?ZG9yaXN3MjY=?= Microsoft Word Document Management 2 2nd Feb 2006 09:56 PM
Static Date howardk Microsoft Excel Worksheet Functions 1 11th Aug 2004 05:55 PM
Change Variable Date to Static/Hard Date CJ Microsoft Word Document Management 2 12th May 2004 05:35 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:45 PM.