View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal Robert Crandal is offline
external usenet poster
 
Posts: 309
Default Storing time formats in strings

Cell "A1" is formatted to accept time data in the format of:

[h]:mm

If I run the following code:

Dim s as String
s = Range("A1").Value
MsgBox s

The message box will display a long floating point number
instead of the time that is displayed in the cell. Is there
a way to store the time that is displayed in a cell into a
string variable??

thnak you