Excel Question (1 Viewer)

[Anthony]

I applied this to 4 spreadsheets today. I also added a dropdown menu. Indebted.

 

[Anthony]

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.

 

[Cormcolash]

That's an excellent question

 

[seanc]

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.

Right click cell - Format cell - date, surely?

I use Open Office more than Excel, but it'll be something like that.

 

[Anthony]

no, that's not it. That keeps the formula. I want to get rid of the formula.

if the formula results in 10/12/2023, I want the cell to have no formula but still say 10/12/2023.

 

[seanc]

Oh right.
There is something in format menu that lets you do that. IIRC, do what I said, then format again to say text only or something.

It definitely can be done, I'm just rusty.

 

[chris d]

Copy and Paste Values?

 

[pete]

Copy and Paste Values?

That’s how I’d do it.

If the cell with the formula doesn’t have the formula then how’s it going to have the result? Classic time travel paradox.

 

[pete]

Turns out you can do it with a VBA function [PutResult()] to copy a formula’s output to another cell, but I wouldn’t bother.

 

[Anthony]

hmmm, that's not working for me.

 

[Anthony]

I'm thinking like a photoshop user. I want to "flatten" the cell.

 

[pete]

hmmm, that's not working for me.

Paste Values, not paste. Copy the formula then right click on the target cell & choose the clipboard icon with the 123

 

[Anthony]

Paste Values, not paste

this will work, thanks!

 

[Cormcolash]

To view this content we will need your consent to set third party cookies.
For more detailed information, see our cookies page.

Accept third party cookies

 

[Cornu Ammonis]

To view this content we will need your consent to set third party cookies.
For more detailed information, see our cookies page.

Accept third party cookies

Excel is a language, can’t you read?

 

[GARYXKNIFEDX]

To view this content we will need your consent to set third party cookies.
For more detailed information, see our cookies page.

Accept third party cookies

Excel is a band