Excel like a finance pro.
VBA · Ranges
Value, Value2, Text
Value returns the cell value (dates as Date), Value2 the raw number, Text what is displayed.
When to use it
Value returns cell content with dates as Date and currency as Currency; Value2 returns the raw number (dates as serials); Text returns exactly what is displayed, as text.
The code
- Code
Range("A1").Value2
Worked examples
Value
Range("A1").Value → A Date if the cell is formatted as a date
Convenient.
Value2
Range("A1").Value2 → The serial number, faster and no conversion
Preferred in loops.
Text
Range("A1").Text → The displayed text, like "$1,234.50" or "####"
What the user sees.
Worth knowing
- Use Value2 for speed and to avoid surprise conversions.
- Text is slow and returns #### when the column is narrow.
- Formula and FormulaR1C1 give the formula itself.
Where it goes wrong
- Value converts dates and currency in ways that surprise comparisons.
- Text depends on column width.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.