If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Change Date Format to Specific Text Format When Copying
I have a certain cell that is used to input a date. I want to be able to
push a button and copy this date to antoher cell, however I need the formatting to change from the original date format to a text format that goes yyyy-mm-dd. I've tried using a custom format and then changing that to text but the date just changes to a number. Any suggestions? Thanks Adam Bush |
#2
|
|||
|
|||
Change Date Format to Specific Text Format When Copying
Hi Adam,
I think you can use a formula to copy the datefrom the original input cell to the destination cell. If for example your input cell is A1, in the destination cell you can type the following formula: =TEXT(A1,"yyyy-mm-dd") Nel , m ha scritto: I have a certain cell that is used to input a date. I want to be able to push a button and copy this date to antoher cell, however I need the formatting to change from the original date format to a text format that goes yyyy-mm-dd. I've tried using a custom format and then changing that to text but the date just changes to a number. Any suggestions? Thanks Adam Bush -- (I'm not sure of names of menus, options and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
#3
|
|||
|
|||
Change Date Format to Specific Text Format When Copying
If you want to convert the date to text, use the TEXT function.
=TEXT(A2,"yyyy-mm-dd") -- David Biddulph " m wrote in message ... I have a certain cell that is used to input a date. I want to be able to push a button and copy this date to antoher cell, however I need the formatting to change from the original date format to a text format that goes yyyy-mm-dd. I've tried using a custom format and then changing that to text but the date just changes to a number. Any suggestions? Thanks Adam Bush |
#4
|
|||
|
|||
Change Date Format to Specific Text Format When Copying
Thanks for your help guys!
"Franz Verga" wrote: Hi Adam, I think you can use a formula to copy the datefrom the original input cell to the destination cell. If for example your input cell is A1, in the destination cell you can type the following formula: =TEXT(A1,"yyyy-mm-dd") Nel , m ha scritto: I have a certain cell that is used to input a date. I want to be able to push a button and copy this date to antoher cell, however I need the formatting to change from the original date format to a text format that goes yyyy-mm-dd. I've tried using a custom format and then changing that to text but the date just changes to a number. Any suggestions? Thanks Adam Bush -- (I'm not sure of names of menus, options and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
#5
|
|||
|
|||
Change Date Format to Specific Text Format When Copying
hi
with the date in b2 and wanting to move it to e3 as text, something like this might work..... sub changetotext() Range("E3").Formula = "=Text(B2, ""mm/dd/yyyy"")" Range("E3").Copy Range("E3").PasteSpecial xlPasteValues end sub this way it would work of a button. regards FSt1 " wrote: I have a certain cell that is used to input a date. I want to be able to push a button and copy this date to antoher cell, however I need the formatting to change from the original date format to a text format that goes yyyy-mm-dd. I've tried using a custom format and then changing that to text but the date just changes to a number. Any suggestions? Thanks Adam Bush |
Thread Tools | |
Display Modes | |
|
|