Thread
:
Change Date Format to Specific Text Format When Copying
View Single Post
#
4
Posted to microsoft.public.excel.misc
[email protected]
external usenet poster
Posts: 168
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
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]