Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Showing a calculated Date as a string
In my code I have calculated the date using the DateSerial command.
This seems to work fine and gives the correct date when I use: Debug.Print MyDate 29 Feb 2004 However I'm trying now to assign this date to a name as a string so that I can use it in concatenated text. I also don't want to write the value directly to the spreadsheet, so the instruction I am using is ActiveWorkbook.Names.Add Name:="FinYear", RefersTo:=MyDate Ths is not saving the date a a string but instead is giving me a serial no value. Can anybody tell me a way around this? .- -. Bye Bye /|6 6|\ - Pavlos {/(_0_)\} / ^ \_ (/_/^\_\) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date showing incorrect. 30:00 hrs showing 06:00 | Excel Discussion (Misc queries) | |||
Date showing as numeric value in a text string formula | Excel Discussion (Misc queries) | |||
Calculated Textbox not showing proper results. | Excel Discussion (Misc queries) | |||
How can a calculated value be displayed wiyhin a text string | Excel Discussion (Misc queries) | |||
Calculated Fields showing error results | Excel Discussion (Misc queries) |