| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to convert text into different format?
Does anyone have any suggestions on how to convert text into different format?
For example, "2008-09-24" in cell A1, I would like to convert the text within cell A1 into dd-mm-yyyy format, does anyone have any suggestions? Thanks in advance for any suggestions Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to convert text into different format?
Hi Eric,
In Excel 2003, right-click the cell(s). Choose Format Cells. In the Format Cells dialog box, in the Number tab, choose Date. Under Type (right-hand side), choose the format you want. "Eric" wrote: Does anyone have any suggestions on how to convert text into different format? For example, "2008-09-24" in cell A1, I would like to convert the text within cell A1 into dd-mm-yyyy format, does anyone have any suggestions? Thanks in advance for any suggestions Eric |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to convert text into different format?
Eric,
Your question contains the answer you need... Follow the step given by Zorrina and enter dd-mm-yyyy as the format... :-) "Zorrina" wrote: Hi Eric, In Excel 2003, right-click the cell(s). Choose Format Cells. In the Format Cells dialog box, in the Number tab, choose Date. Under Type (right-hand side), choose the format you want. "Eric" wrote: Does anyone have any suggestions on how to convert text into different format? For example, "2008-09-24" in cell A1, I would like to convert the text within cell A1 into dd-mm-yyyy format, does anyone have any suggestions? Thanks in advance for any suggestions Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
| How to convert text into date format? | Excel Worksheet Functions | |||
| How to convert fraction format to text format ...... | New Users to Excel | |||
| How do I convert a time to text format. | Excel Discussion (Misc queries) | |||
| convert number to text and format it. | Excel Worksheet Functions | |||
Linear Mode
