Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date to text format question
I am attempting to convert a date to text, and am having trouble with
the formatting. Specifically, I wish to convert a date in the form mm/ dd/yyyy to text in exactly the same format. I am using excel 2000. Using the command =Text(Text,text-format), I am having trouble with the format piece. "Help" tell me that the format code is based on he "format cells numeric" definitions. My problem is that the code appears to be a number, and nowhere can I find what number produces what defined text format! Can someone either give me the code I need, or point me in the right direction to get an answer. Thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date to text format question
No need to post again look in you other post and tell me what's wrong with my
answer and we'll fix it "JHB" wrote: I am attempting to convert a date to text, and am having trouble with the formatting. Specifically, I wish to convert a date in the form mm/ dd/yyyy to text in exactly the same format. I am using excel 2000. Using the command =Text(Text,text-format), I am having trouble with the format piece. "Help" tell me that the format code is based on he "format cells numeric" definitions. My problem is that the code appears to be a number, and nowhere can I find what number produces what defined text format! Can someone either give me the code I need, or point me in the right direction to get an answer. Thanks in advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date to text format question
what if you will use formatcells text format and not the formula
and if you want to use formula you can use it like this. =text(a1,"MM/DD/YYYY") where a1 is the cell contains date. "Mike H" wrote: No need to post again look in you other post and tell me what's wrong with my answer and we'll fix it "JHB" wrote: I am attempting to convert a date to text, and am having trouble with the formatting. Specifically, I wish to convert a date in the form mm/ dd/yyyy to text in exactly the same format. I am using excel 2000. Using the command =Text(Text,text-format), I am having trouble with the format piece. "Help" tell me that the format code is based on he "format cells numeric" definitions. My problem is that the code appears to be a number, and nowhere can I find what number produces what defined text format! Can someone either give me the code I need, or point me in the right direction to get an answer. Thanks in advance |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date to text format question
Format|Cells|Text will display the date as a number
"Satyendra_Haldaur" wrote: what if you will use formatcells text format and not the formula and if you want to use formula you can use it like this. =text(a1,"MM/DD/YYYY") where a1 is the cell contains date. "Mike H" wrote: No need to post again look in you other post and tell me what's wrong with my answer and we'll fix it "JHB" wrote: I am attempting to convert a date to text, and am having trouble with the formatting. Specifically, I wish to convert a date in the form mm/ dd/yyyy to text in exactly the same format. I am using excel 2000. Using the command =Text(Text,text-format), I am having trouble with the format piece. "Help" tell me that the format code is based on he "format cells numeric" definitions. My problem is that the code appears to be a number, and nowhere can I find what number produces what defined text format! Can someone either give me the code I need, or point me in the right direction to get an answer. Thanks in advance |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date to text format question
Try this:
=TEXT(A1," m/d/yyyy") "JHB" wrote: I am attempting to convert a date to text, and am having trouble with the formatting. Specifically, I wish to convert a date in the form mm/ dd/yyyy to text in exactly the same format. I am using excel 2000. Using the command =Text(Text,text-format), I am having trouble with the format piece. "Help" tell me that the format code is based on he "format cells numeric" definitions. My problem is that the code appears to be a number, and nowhere can I find what number produces what defined text format! Can someone either give me the code I need, or point me in the right direction to get an answer. Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting a date to text..Format question | Excel Discussion (Misc queries) | |||
Convert date from text format to date format | Excel Discussion (Misc queries) | |||
Convert date + time text format to date format | Excel Worksheet Functions | |||
Date Format Question | Excel Discussion (Misc queries) | |||
Date Format Question | Excel Worksheet Functions |