FG
💻 Software

How do I force a column in excel to be stored as text?

Fresh5 days ago
Mar 15, 202649545 views
Confidence Score0%
0%

Problem

I have a column of hexadecimal strings: I need excel to store these as strings, not integers or floats.

Error Output

506078
363624
505974
505644

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: How do I force a column in excel to be stored as text?

Low Risk

All you need to do for this one is put a single quote in front of your text. This also works for dates you don't want Excel picking up. eg. You can also format your entire column as text which will override the whole column. In Excel 2007, hilight y…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment