G Guest Jul 17, 2007 #1 i want to convert a cell a1 2007-7-8 to a text type, but i did not know how to set the second parameter of text function. text(a1,??).
i want to convert a cell a1 2007-7-8 to a text type, but i did not know how to set the second parameter of text function. text(a1,??).
R Ron Rosenfeld Jul 17, 2007 #2 i want to convert a cell a1 2007-7-8 to a text type, but i did not know how to set the second parameter of text function. text(a1,??). Click to expand... ?? is any of the date format codes that you want to use. For example: =text(a1,"yyyy-m-d") --ron
i want to convert a cell a1 2007-7-8 to a text type, but i did not know how to set the second parameter of text function. text(a1,??). Click to expand... ?? is any of the date format codes that you want to use. For example: =text(a1,"yyyy-m-d") --ron
G Guest Jul 17, 2007 #3 ok,if i just want use y m d data,how to set ? Ron Rosenfeld said: ?? is any of the date format codes that you want to use. For example: =text(a1,"yyyy-m-d") --ron Click to expand...
ok,if i just want use y m d data,how to set ? Ron Rosenfeld said: ?? is any of the date format codes that you want to use. For example: =text(a1,"yyyy-m-d") --ron Click to expand...
R Ron Rosenfeld Jul 17, 2007 #4 ok,if i just want use y m d data,how to set ? Click to expand... I don't understand your question. What is "y m d data"? How do you want to "use" it? In the formula I gave you, A1 must contain a date (which, in Excel,is a serial number). --ron
ok,if i just want use y m d data,how to set ? Click to expand... I don't understand your question. What is "y m d data"? How do you want to "use" it? In the formula I gave you, A1 must contain a date (which, in Excel,is a serial number). --ron
