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. |
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. |
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