Excel VBA - Value vs Text

Value vs Text


Sheets(1).Cells(6, 3).Value will give the raw value in the cell.

Sheets(1).Cells(6, 3).Text will give what you see in the cell.