| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display time in text
Dear expert,
Want to display date in 20090429. I go to format and choose YYYYMMDD. It works. Then I use "concatenate" or "=A1&A2" It becomes 39932. The fact is that I want to concatenate a file name and add date at the back for saving purpose. I have tried ... =Year(A1) =Month(A1) =Date(A1) But it gives 2009429 rather than 20090429. I changed number format to 00.00 in order to display 04 for month. it works for display only .... but concatenate ... it becomes 2009429 again. Also, I have tried TEXT(A2,"00") and concatenate ... does not work too ! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display time in text
Do it this way:
=A1 & TEXT(A2,"yyyymmdd") assuming your filename is in A1 and the date in A2. Hope this helps. Pete On Apr 29, 10:07*am, Elton Law wrote: Dear expert, Want to display date in 20090429. I go to format and choose YYYYMMDD. It works. Then I use "concatenate" or "=A1&A2" It becomes 39932. The fact is that I want to concatenate a file name and add date at the back for saving purpose. I have tried ... =Year(A1) =Month(A1) =Date(A1) But it gives 2009429 rather than 20090429. I changed number format to 00.00 in order to display 04 for month. it works for display only .... but concatenate ... it becomes 2009429 again. Also, I have tried TEXT(A2,"00") and concatenate ... does not work too ! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display time in text
In A1 enter:
FileName in A2 enter: =TEXT(TODAY(),"yyyymmdd") elsewhere enter: =A1 & A2 to display: FileName20090429 -- Gary''s Student - gsnu200850 "Elton Law" wrote: Dear expert, Want to display date in 20090429. I go to format and choose YYYYMMDD. It works. Then I use "concatenate" or "=A1&A2" It becomes 39932. The fact is that I want to concatenate a file name and add date at the back for saving purpose. I have tried ... =Year(A1) =Month(A1) =Date(A1) But it gives 2009429 rather than 20090429. I changed number format to 00.00 in order to display 04 for month. it works for display only .... but concatenate ... it becomes 2009429 again. Also, I have tried TEXT(A2,"00") and concatenate ... does not work too ! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display time in text
That's work ... Thanks a lot ....
Smart GUY !!! "Gary''s Student" wrote: In A1 enter: FileName in A2 enter: =TEXT(TODAY(),"yyyymmdd") elsewhere enter: =A1 & A2 to display: FileName20090429 -- Gary''s Student - gsnu200850 "Elton Law" wrote: Dear expert, Want to display date in 20090429. I go to format and choose YYYYMMDD. It works. Then I use "concatenate" or "=A1&A2" It becomes 39932. The fact is that I want to concatenate a file name and add date at the back for saving purpose. I have tried ... =Year(A1) =Month(A1) =Date(A1) But it gives 2009429 rather than 20090429. I changed number format to 00.00 in order to display 04 for month. it works for display only .... but concatenate ... it becomes 2009429 again. Also, I have tried TEXT(A2,"00") and concatenate ... does not work too ! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display time in text
Replace Book1, Sheet1 and Sheet2 to suit your requirement
=COUNTIF([Book1]Sheet1!$A:$A,A2)+COUNTIF([Book1]Sheet2!$A:$A,A2) If this post helps click Yes --------------- Jacob Skaria "Gary''s Student" wrote: In A1 enter: FileName in A2 enter: =TEXT(TODAY(),"yyyymmdd") elsewhere enter: =A1 & A2 to display: FileName20090429 -- Gary''s Student - gsnu200850 "Elton Law" wrote: Dear expert, Want to display date in 20090429. I go to format and choose YYYYMMDD. It works. Then I use "concatenate" or "=A1&A2" It becomes 39932. The fact is that I want to concatenate a file name and add date at the back for saving purpose. I have tried ... =Year(A1) =Month(A1) =Date(A1) But it gives 2009429 rather than 20090429. I changed number format to 00.00 in order to display 04 for month. it works for display only .... but concatenate ... it becomes 2009429 again. Also, I have tried TEXT(A2,"00") and concatenate ... does not work too ! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display time in text
Sorry, the below is a wrong post..
-- If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Replace Book1, Sheet1 and Sheet2 to suit your requirement =COUNTIF([Book1]Sheet1!$A:$A,A2)+COUNTIF([Book1]Sheet2!$A:$A,A2) If this post helps click Yes --------------- Jacob Skaria "Gary''s Student" wrote: In A1 enter: FileName in A2 enter: =TEXT(TODAY(),"yyyymmdd") elsewhere enter: =A1 & A2 to display: FileName20090429 -- Gary''s Student - gsnu200850 "Elton Law" wrote: Dear expert, Want to display date in 20090429. I go to format and choose YYYYMMDD. It works. Then I use "concatenate" or "=A1&A2" It becomes 39932. The fact is that I want to concatenate a file name and add date at the back for saving purpose. I have tried ... =Year(A1) =Month(A1) =Date(A1) But it gives 2009429 rather than 20090429. I changed number format to 00.00 in order to display 04 for month. it works for display only .... but concatenate ... it becomes 2009429 again. Also, I have tried TEXT(A2,"00") and concatenate ... does not work too ! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I wrap text, excel hides the text display | Excel Discussion (Misc queries) | |||
| if a cell contains text, then display date and time | Excel Discussion (Misc queries) | |||
| Time display | Excel Discussion (Misc queries) | |||
| Find text within cell then display text to left | Excel Discussion (Misc queries) | |||
| Time Display ? | Excel Worksheet Functions | |||
![Elton Law[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
