Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - convert dates to text but appear as a date format
I have a column of dates, formatted as dd/mm/yyyy. I need these cells to be
formatted as text as I need to export and upload this information to another program. If I merely format the cells as text, I get a numeric code. I need that to read as a date dd/mm/yyyy, but in a cell formatted as text. Help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - convert dates to text but appear as a date format
Select the column then try this:
- Press Ctrl+C twice and click the Paste clipboard Icon - Format Cells Text OK - Edit Paste Special Text OK (To convert all data to text select the whole sheet instead.) "Michele" wrote: I have a column of dates, formatted as dd/mm/yyyy. I need these cells to be formatted as text as I need to export and upload this information to another program. If I merely format the cells as text, I get a numeric code. I need that to read as a date dd/mm/yyyy, but in a cell formatted as text. Help! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - convert dates to text but appear as a date format
hi
add a blank column next you date column then enter this formula assuming your date column is A and helper column is B. =text(A2,"dd/mm/yyyy") copy down as far as needed. copy column B and paste special values. dates are now text. delete column A (if no longer needed.) Regards FSt1 "Michele" wrote: I have a column of dates, formatted as dd/mm/yyyy. I need these cells to be formatted as text as I need to export and upload this information to another program. If I merely format the cells as text, I get a numeric code. I need that to read as a date dd/mm/yyyy, but in a cell formatted as text. Help! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - convert dates to text but appear as a date format
Another option: Data Text to Columns Next Next Text Finish
"Lori" wrote: Select the column then try this: - Press Ctrl+C twice and click the Paste clipboard Icon - Format Cells Text OK - Edit Paste Special Text OK (To convert all data to text select the whole sheet instead.) "Michele" wrote: I have a column of dates, formatted as dd/mm/yyyy. I need these cells to be formatted as text as I need to export and upload this information to another program. If I merely format the cells as text, I get a numeric code. I need that to read as a date dd/mm/yyyy, but in a cell formatted as text. Help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert date + time text format to date format | Excel Worksheet Functions | |||
How to convert text into date format? | Excel Discussion (Misc queries) | |||
Help: How do I convert a text date into a real date format | Excel Worksheet Functions | |||
Date format not correct when you convert a CSV text file in Excel | Excel Discussion (Misc queries) | |||
How do I convert dates to text keeping the format? | Excel Discussion (Misc queries) |