Truncate leading zeros in text field (Excel) is a pain

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Excel truncates our report fields that contain numbers; first it converts a
text field containing numbers to exponent, and when we convert it to text it
truncates leading zeros. Trying to find a quick way to change so many
fields.
 
Where is your data coming from?
You should see if it is possible to format your cells as text before
entering the data (Format / Cells / Number / Text).

Bill Manville
MVP - Microsoft Excel, Oxford, England
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Open CSV as txt data 5
Export Excel tuncating leading zeros while export to excel from da 1
How to convert text files into excel 3
leading zeros truncated in text field 1
How do I print leading zeros in an Access report? 1
numeric field that accepts leading zeros 1
RDBMerge Text limit 0

Back
Top