ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   pinning an @today date and time (https://www.excelbanter.com/charts-charting-excel/206660-pinning-%40today-date-time.html)

bflorox

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.

bflorox

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.


bflorox

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.



All times are GMT +1. The time now is 04:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com