Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format a date to text
1) I need to convert a date to text format but when I do so it changes the
data completely. ie 9/2/2008 changes to 39639. Is there a way to save the date as text without changing the data? 2) Another similiar question, I have a zip code that is 00969 but in excel it shows as 969, then I format it as a 6 digit integer. When I convert it to text, it goes back to 969. Is there anyway to keep the 00969 in text without having to retype as there are over 1,000 cells. Thank you, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
format a date to text
For both things use apostrophe( ' ) before the values
ie., '9/2/2008 and '000969 NeSchw6G wrote: 1) I need to convert a date to text format but when I do so it changes the data completely. ie 9/2/2008 changes to 39639. Is there a way to save the date as text without changing the data? 2) Another similiar question, I have a zip code that is 00969 but in excel it shows as 969, then I format it as a 6 digit integer. When I convert it to text, it goes back to 969. Is there anyway to keep the 00969 in text without having to retype as there are over 1,000 cells. Thank you, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
format a date to text
Is it possible to insert an apostrophe with out doing manually?
"muddan madhu" wrote: For both things use apostrophe( ' ) before the values ie., '9/2/2008 and '000969 NeSchw6G wrote: 1) I need to convert a date to text format but when I do so it changes the data completely. ie 9/2/2008 changes to 39639. Is there a way to save the date as text without changing the data? 2) Another similiar question, I have a zip code that is 00969 but in excel it shows as 969, then I format it as a 6 digit integer. When I convert it to text, it goes back to 969. Is there anyway to keep the 00969 in text without having to retype as there are over 1,000 cells. Thank you, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
format a date to text
Change the format of the date column to the date format you want
eg 9-Sep-2008, September 9, 2008 etc. They will display and print as text but still be stored as numbers represeting days from the Excle start date... "NeSchw6G" wrote: 1) I need to convert a date to text format but when I do so it changes the data completely. ie 9/2/2008 changes to 39639. Is there a way to save the date as text without changing the data? 2) Another similiar question, I have a zip code that is 00969 but in excel it shows as 969, then I format it as a 6 digit integer. When I convert it to text, it goes back to 969. Is there anyway to keep the 00969 in text without having to retype as there are over 1,000 cells. Thank you, |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
format a date to text
I don't think that works for my purpose because the final format needs to be
text as it is a tab delimited file. "Sheeloo" wrote: Change the format of the date column to the date format you want eg 9-Sep-2008, September 9, 2008 etc. They will display and print as text but still be stored as numbers represeting days from the Excle start date... "NeSchw6G" wrote: 1) I need to convert a date to text format but when I do so it changes the data completely. ie 9/2/2008 changes to 39639. Is there a way to save the date as text without changing the data? 2) Another similiar question, I have a zip code that is 00969 but in excel it shows as 969, then I format it as a 6 digit integer. When I convert it to text, it goes back to 969. Is there anyway to keep the 00969 in text without having to retype as there are over 1,000 cells. Thank you, |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
format a date to text
Try this one
suppose u have date in A1 then in B1 put this formula = Text(A1,"dd/mm/ yyyy") similary for the value 969 = Text(A2,"000000") = 000969 On Sep 11, 1:27*am, NeSchw6G wrote: Is it possible to insert an apostrophe with out doing manually? "muddan madhu" wrote: For both things use apostrophe( ' ) before the values ie., '9/2/2008 and '000969 NeSchw6G wrote: 1) I need to convert a date to text format but when I do so it changes the data completely. ie 9/2/2008 changes to 39639. Is there a way to save the date as text without changing the data? 2) Another similiar question, I have a zip code that is 00969 but in excel it shows as 969, then I format it as a 6 digit integer. *When I convert it to text, it goes back to 969. *Is there anyway to keep the 00969 in text without having to retype as there are over 1,000 cells. Thank you, |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
format a date to text
I tested with Excel 2003 and saved my file as tab delimited (txt) and got the
dates saved similar to the name column I had... If you want to put quotes around the date then use this; =""""&TEXT(A1,"dd/mm/yyyy") &"""" "NeSchw6G" wrote: I don't think that works for my purpose because the final format needs to be text as it is a tab delimited file. "Sheeloo" wrote: Change the format of the date column to the date format you want eg 9-Sep-2008, September 9, 2008 etc. They will display and print as text but still be stored as numbers represeting days from the Excle start date... "NeSchw6G" wrote: 1) I need to convert a date to text format but when I do so it changes the data completely. ie 9/2/2008 changes to 39639. Is there a way to save the date as text without changing the data? 2) Another similiar question, I have a zip code that is 00969 but in excel it shows as 969, then I format it as a 6 digit integer. When I convert it to text, it goes back to 969. Is there anyway to keep the 00969 in text without having to retype as there are over 1,000 cells. Thank you, |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
format a date to text
It worked! Thank you!
"Sheeloo" wrote: I tested with Excel 2003 and saved my file as tab delimited (txt) and got the dates saved similar to the name column I had... If you want to put quotes around the date then use this; =""""&TEXT(A1,"dd/mm/yyyy") &"""" "NeSchw6G" wrote: I don't think that works for my purpose because the final format needs to be text as it is a tab delimited file. "Sheeloo" wrote: Change the format of the date column to the date format you want eg 9-Sep-2008, September 9, 2008 etc. They will display and print as text but still be stored as numbers represeting days from the Excle start date... "NeSchw6G" wrote: 1) I need to convert a date to text format but when I do so it changes the data completely. ie 9/2/2008 changes to 39639. Is there a way to save the date as text without changing the data? 2) Another similiar question, I have a zip code that is 00969 but in excel it shows as 969, then I format it as a 6 digit integer. When I convert it to text, it goes back to 969. Is there anyway to keep the 00969 in text without having to retype as there are over 1,000 cells. Thank you, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date in text format as a real date | Excel Worksheet Functions | |||
Convert date from text format to date format | Excel Discussion (Misc queries) | |||
Convert date + time text format to date format | Excel Worksheet Functions | |||
Concatenating a Text and a Date without losing orginal Date Format | Excel Discussion (Misc queries) | |||
Help: How do I convert a text date into a real date format | Excel Worksheet Functions |