| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
pinning an @today date and time
I have a 2-column ss. One column is a value and the other is the current
date and time the value was entered. I have set the date and time to appear only if a value is entered in the neighboring column. I want the date and time to always be there as the date and time it was when it was created. How can I pin that value so they don't change every time I open up the ss? Thanks. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
pinning an @today date and time
date and time are from @now, not @today. I don't want those values to change
every time I make an entry. "bflorox" wrote: I have a 2-column ss. One column is a value and the other is the current date and time the value was entered. I have set the date and time to appear only if a value is entered in the neighboring column. I want the date and time to always be there as the date and time it was when it was created. How can I pin that value so they don't change every time I open up the ss? Thanks. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
pinning an @today date and time
Sorry, meant to post to "Worksheet Functions". ? has been answered there.
Thanks. "bflorox" wrote: date and time are from @now, not @today. I don't want those values to change every time I make an entry. "bflorox" wrote: I have a 2-column ss. One column is a value and the other is the current date and time the value was entered. I have set the date and time to appear only if a value is entered in the neighboring column. I want the date and time to always be there as the date and time it was when it was created. How can I pin that value so they don't change every time I open up the ss? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Question about pinning a document to the Recent Documents list | Excel Discussion (Misc queries) | |||
| IF TODAY equals date in cell A10, or if TODAY is beyond that date | Excel Worksheet Functions | |||
| MAX figure within a date range as a function of today()'s date | Excel Worksheet Functions | |||
| SUMIF within date range as a function of today()'s date | Excel Worksheet Functions | |||
| how do I get a current time using =TODAY() instead of 12:00 AM | Excel Discussion (Misc queries) | |||
Linear Mode
