How to force Excel not to do arithmetics when reading data from cell?

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

The data in cell is:
22:35

using .value property the value retrieved is: 0.732638888888889

I need to retrieve that data in original form.
How?
Jack
 
You can use the Text property.


Jack said:
The data in cell is:
22:35

using .value property the value retrieved is: 0.732638888888889

I need to retrieve that data in original form.
How?
Jack
Click to expand...
 
Jack,

just for added info, what you should have gotten (and I got) with the Value property is
0.940972222222222 if the cell contains 22:35. This is a date-time value for 10:35 PM, or
22:35. The Text property gave you the date-time formatted version of the cell contents,
which is what you wanted.
 
You must log in or register to reply here.

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

Retrieving data from a cell in the last row containing data in the worksheet 1
VBA - retrieve data on last create named range from previous inserted named range 0
Access #Error & Excel Pivot 0
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
Retrieving Data From Excel 7
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Retrieve data from Access database and fill data in form 0
How to know the actual column? 1

Back
Top