format of date cells

[grutledge]

i have some dates listed as 01/01/05 and have changed the format to read 010105. is there anyway to copy these numbers to cells with general formatting as i would like to add a letter to them so 010105 becomes 010105v?

 

[SteveO59L]

If you add a letter to the end, Excel will read the date as text.

So, if your date is in A1 and your text in B1, in C1 =A1&B1.


HTH

 

[sjsmith]

In date format 12012003, how do I change the first day of the month to the last day of the month? I have several dates of various months and years but all have 01 as the day and I need it to reflect the last day for each month.

Thanks

 

[grutledge]

010105=A1
V=B1
A1&B1=C1
C1=38353V for some reason (reverts back to excel date)

 

[grutledge]

i tried using =CONCATENATE(YEAR(M25),MONTH(M25),DAY(M25)) but it give me the value 200511. i'd like it to read 050101