- Thread starter
- #21
I applied this to 4 spreadsheets today. I also added a dropdown menu. Indebted.
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
New excel question here:
Say a cell is the result of a complicated formula, "=D23+(B23*7)-1" for example. Which is a date.
Is there a way to convert the contents that cell to just the date that is in that cell, ie not the result of the formula?
Thanks nerds.
That’s how I’d do it.Copy and Paste Values?
Paste Values, not paste. Copy the formula then right click on the target cell & choose the clipboard icon with the 123hmmm, that's not working for me.
this will work, thanks!Paste Values, not paste
Upgrade your account now to disable all ads...
Upgrade nowWe use essential cookies to make this site work, and optional cookies to enhance your experience.