| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date
Hello All,
I would like to convert the date that is generated by the "Now()" formula in a work sheet to just the text of the date. i.e. result in text as 12/01/2004 Thanks in advance |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date
=TEXT(LEFT(NOW(),10),"dd/mm/yyyy")
Sharad "Tim" wrote in message ... Hello All, I would like to convert the date that is generated by the "Now()" formula in a work sheet to just the text of the date. i.e. result in text as 12/01/2004 Thanks in advance |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date
ActiveCell.Value = Date
ActiveCell.Numberformat = "mm/dd/yyyy" -- Regards, Tom Ogilvy "Tim" wrote in message ... Hello All, I would like to convert the date that is generated by the "Now()" formula in a work sheet to just the text of the date. i.e. result in text as 12/01/2004 Thanks in advance |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date
Not sure why you need text - you could just use
=TODAY() and format it with Format/Cells/Date. However, if you want it as text, use =TEXT(TODAY(),"mm/dd/yyyy") In article , "Tim" wrote: Hello All, I would like to convert the date that is generated by the "Now()" formula in a work sheet to just the text of the date. i.e. result in text as 12/01/2004 Thanks in advance |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date
Only
=TEXT(NOW(),"dd/mm/yyyy") should do. "Sharad Naik" wrote in message ... =TEXT(LEFT(NOW(),10),"dd/mm/yyyy") Sharad "Tim" wrote in message ... Hello All, I would like to convert the date that is generated by the "Now()" formula in a work sheet to just the text of the date. i.e. result in text as 12/01/2004 Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate including a date so that the date appears as a date | Excel Worksheet Functions | |||
| date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
| Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Linear Mode
