| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Static date | Excel Discussion (Misc queries) | |||
| Static date formula | Excel Discussion (Misc queries) | |||
| static date | Excel Worksheet Functions | |||
| Static Date | Excel Discussion (Misc queries) | |||
| DATE STATIC | Excel Worksheet Functions | |||
Linear Mode
