Storing time formats in strings

R

Robert Crandal

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List found strings on sheet 34
Storing values 6
Dim problems 7
Add to a "number as text" 10
Display entire number in cell 3
Named Range maker code 9
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Time Calculations Help 4

Top