How to stop Excel from Auto-formatting and making it work like a number crunching program
Fresh3 days ago
Mar 15, 2026160754 viewsConfidence Score0%
0%
Problem
I have a real problem with Excel in csv files where it is formatting numbers in certain ways and I cannot seem to get Excel to display the data right no matter what I do. Imagine I have a colum called "Product Reference". Within that column I have many IDs of the type: 001145 55666 02133 Whenever I…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How to stop Excel from Auto-formatting and making it work like a number crunching program
Low Risk
You need to specify in the csv file that it is text. You do this by putting your number in quotes and preceeding with and equal sign, eg: The easiest way to do this would be to do a find-replace on with , replacing end of lines (you might need to us…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix