| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert date to text
I have dates like 02/08/08 in column B
I want to convert them to a text like D02/08/08 Everything I have tried gives an error or D38295 or the like where the number part is the serial date. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert date to text
Hi,
Did you try this? ="D"&TEXT(B1,"dd/mm/yy") Mike "Gene Augustin" wrote: I have dates like 02/08/08 in column B I want to convert them to a text like D02/08/08 Everything I have tried gives an error or D38295 or the like where the number part is the serial date. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert date to text
Try:
="D"&text(a1,"mm/dd/yy") Regards, Fred "Gene Augustin" wrote in message m... I have dates like 02/08/08 in column B I want to convert them to a text like D02/08/08 Everything I have tried gives an error or D38295 or the like where the number part is the serial date. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert date to text
I have dates like 02/08/08 in column B
I want to convert them to a text like D02/08/08 Assuming that's mm/dd/yy format: ="D"&TEXT(B1,"mm/dd/yy") -- Biff Microsoft Excel MVP "Gene Augustin" wrote in message m... I have dates like 02/08/08 in column B I want to convert them to a text like D02/08/08 Everything I have tried gives an error or D38295 or the like where the number part is the serial date. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert date to text
Hi,
Well I think you've seen the solution. However, if you are ok with a non-text solution then Select the cells and choose Format, Cells, Number tab, Custom and enter the following on the Type line. "D"m/d/yyyy -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Gene Augustin" wrote: I have dates like 02/08/08 in column B I want to convert them to a text like D02/08/08 Everything I have tried gives an error or D38295 or the like where the number part is the serial date. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert date to text
Here is a way to do it without the concatenation operation shown in the
first 3 responses (note the backslash in front of the D)... =TEXT(A1,"\Dmm/dd/yy") -- Rick (MVP - Excel) "Gene Augustin" wrote in message m... I have dates like 02/08/08 in column B I want to convert them to a text like D02/08/08 Everything I have tried gives an error or D38295 or the like where the number part is the serial date. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert date to text
Use following formula ="D" & TEXT(A1,"mm/dd/yy") Chris ------ Convert your Excel spreadsheet into an online calculator. http://www.spreadsheetconverter.com -- Chris Bode |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Date to Text | Excel Worksheet Functions | |||
| convert text to date | Excel Discussion (Misc queries) | |||
| convert a text date to a true date | Excel Discussion (Misc queries) | |||
| how do i convert text to date (mm/yy text to mm/dd/yyyy date)? | Excel Discussion (Misc queries) | |||
| Help: How do I convert a text date into a real date format | Excel Worksheet Functions | |||
Linear Mode
