How to read formatted cell value data using excel vba?

Question

What I'm trying to is read formatted cell value in excel 2007 using VBA.

For example I have a cell with value "01/01/2015" and when formatted it looks like Jan/2015. Is there a way to read that formatted value Jan/2015 into a variable instead of "01/01/2015"?

Thank you

score 1 · Accepted Answer · answered Jan 08 '14 at 12:10

1

try to use

someVariable = Range("A1").Text

instead

someVariable = Range("A1").Value

you can read more here

answered Jan 08 '14 at 12:10

Dmitry Pavliv

34,126
12
75
77

How to read formatted cell value data using excel vba?

1 Answers1