Skip to main content
Web Applications

Return to Question

added 8 characters in body; edited title
Source Link
ale
ale
  • 52.9k
  • 42
  • 165
  • 314

Google Sheets - Copy Date Value and Paste as actual Date not number

I have a Google sheet with a cell (D1) that contains a formula (=TODAY()=TODAY()) to show the current date. I am trying to create a macro that will simply copy the value of D1 as displayed (ie:e.g., "5/18/2018") instead of the formula and then display that value as an actual date (ie:i.e., "5/18/2018"). When I use Google sheets PASTE SPECIAL (Paste Value Only)PASTE SPECIAL (Paste Value Only) it actually displays the number "43238" instead of "5/18/2018". How do make it paste the actual date instead of the number?

Google Sheets - Copy Date Value and Paste as actual Date not number

I have a Google sheet with a cell (D1) that contains a formula (=TODAY()) to show the current date. I am trying to create a macro that will simply copy the value of D1 as displayed (ie: "5/18/2018") instead of the formula and then display that value as an actual date (ie: "5/18/2018"). When I use Google sheets PASTE SPECIAL (Paste Value Only) it actually displays the number "43238" instead of "5/18/2018". How do make it paste the actual date instead of the number?

Copy Date Value and Paste as actual Date not number

I have a Google sheet with a cell (D1) that contains a formula (=TODAY()) to show the current date. I am trying to create a macro that will simply copy the value of D1 as displayed (e.g., "5/18/2018") instead of the formula and then display that value as an actual date (i.e., "5/18/2018"). When I use Google sheets PASTE SPECIAL (Paste Value Only) it actually displays the number "43238" instead of "5/18/2018". How do make it paste the actual date instead of the number?

Source Link
George Benson
George Benson
  • 21
  • 1
  • 2

Google Sheets - Copy Date Value and Paste as actual Date not number

I have a Google sheet with a cell (D1) that contains a formula (=TODAY()) to show the current date. I am trying to create a macro that will simply copy the value of D1 as displayed (ie: "5/18/2018") instead of the formula and then display that value as an actual date (ie: "5/18/2018"). When I use Google sheets PASTE SPECIAL (Paste Value Only) it actually displays the number "43238" instead of "5/18/2018". How do make it paste the actual date instead of the number?