🎨 The Format Painter

Goal: Convert a raw number into a specific text format.
TEXT changes the value into a string, unlike Cell Formatting which only changes the appearance.

Raw Number -
âŦ‡
Format Code: "-"
âŦ‡
Text String -
Ready...

đŸ’ģ Formula Structure

=TEXT(value, format_text)
  • 1. Value: The number to format (e.g., 45285).
  • 2. Format Text: The pattern code in quotes (e.g., "mmm-yy").
-- Apply formatting
=TEXT( A1, "General" )
Final Result:
-

ℹī¸ Cheat Sheet

0
Digit (shows 0 if empty)
#
Digit (hides if empty)
mmm
Short Month (Jan)
dddd
Full Day (Monday)
@
Text Placeholder