How do I set a static date?
 

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?

How do I set a static date?
 

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



--


Regards,


Peo Sjoblom




"Shawn" wrote in message
...
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?

How do I set a static date?
 

See this:

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

--
Biff
Microsoft Excel MVP


"Shawn" wrote in message
...
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?

How do I set a static date?
 

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

How do I set a static date?
 

It's in that link :)


--


Regards,


Peo Sjoblom



"Dave Peterson" wrote in message
...
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

How do I set a static date?
 

Yes, it is!

Peo Sjoblom wrote:

It's in that link :)

--

Regards,

Peo Sjoblom

"Dave Peterson" wrote in message
...
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