Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell date value
OK,
this must be an easy one. I have a named cell. Start_date The cell is formated as date. with a date value 7/1/2010 when trying to get the cell value I do not get the date range("start_date").Value2 It comes out: 40360 so must be something easy. anyone have an answer? thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell date value
Why are you using Value2? Try using this...
Range("Start_Date").Value Or, you can format the date value from Value2 yourself.... Format(Range("Start_Date").Value2, "m/d/yyyy") -- Rick (MVP - Excel) "greg" wrote in message ... OK, this must be an easy one. I have a named cell. Start_date The cell is formated as date. with a date value 7/1/2010 when trying to get the cell value I do not get the date range("start_date").Value2 It comes out: 40360 so must be something easy. anyone have an answer? thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell date value
Greg,
Try this Mydate = Format(Range("start_date"), "dd/mm/yyyy") Mike "greg" wrote: OK, this must be an easy one. I have a named cell. Start_date The cell is formated as date. with a date value 7/1/2010 when trying to get the cell value I do not get the date range("start_date").Value2 It comes out: 40360 so must be something easy. anyone have an answer? thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell date value
Try
=Format(range("start_Date"),"dd-mm-yyyy") If this post helps click Yes --------------- Jacob Skaria "greg" wrote: OK, this must be an easy one. I have a named cell. Start_date The cell is formated as date. with a date value 7/1/2010 when trying to get the cell value I do not get the date range("start_date").Value2 It comes out: 40360 so must be something easy. anyone have an answer? thanks |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell date value
Thanks
What is the diff between value and value2? "Rick Rothstein" wrote in message ... Why are you using Value2? Try using this... Range("Start_Date").Value Or, you can format the date value from Value2 yourself.... Format(Range("Start_Date").Value2, "m/d/yyyy") -- Rick (MVP - Excel) "greg" wrote in message ... OK, this must be an easy one. I have a named cell. Start_date The cell is formated as date. with a date value 7/1/2010 when trying to get the cell value I do not get the date range("start_date").Value2 It comes out: 40360 so must be something easy. anyone have an answer? thanks |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell date value
From the Remarks section of the VBA Help Files for Value2...
"The only difference between this property and the Value property is that the Value2 property doesn't use the Currency and Date data types." The fastest way to check a keyword out in the VBA Help Files is to type the word in any code window and, with the text cursor in or next to the word, press F1. -- Rick (MVP - Excel) "greg" wrote in message ... Thanks What is the diff between value and value2? "Rick Rothstein" wrote in message ... Why are you using Value2? Try using this... Range("Start_Date").Value Or, you can format the date value from Value2 yourself.... Format(Range("Start_Date").Value2, "m/d/yyyy") -- Rick (MVP - Excel) "greg" wrote in message ... OK, this must be an easy one. I have a named cell. Start_date The cell is formated as date. with a date value 7/1/2010 when trying to get the cell value I do not get the date range("start_date").Value2 It comes out: 40360 so must be something easy. anyone have an answer? thanks |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell date value
thanks all
"Jacob Skaria" wrote in message ... Try =Format(range("start_Date"),"dd-mm-yyyy") If this post helps click Yes --------------- Jacob Skaria "greg" wrote: OK, this must be an easy one. I have a named cell. Start_date The cell is formated as date. with a date value 7/1/2010 when trying to get the cell value I do not get the date range("start_date").Value2 It comes out: 40360 so must be something easy. anyone have an answer? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 make 1 date cell automatically change another date cell | Excel Worksheet Functions | |||
date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
Automatically update a cell with a date based on anther cells date | Excel Discussion (Misc queries) | |||
comparing abr. Date Text cell to a date formatted cell | Excel Programming | |||
How to update a cell if a specific date is included in a date rang | Setting up and Configuration of Excel |