Numbers starting in 0

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

Guest

I have a csv file that has PO numbers in it. Some of the PO numbers start
with zero, which is required. When I open the file in Excel 2002, Excel
drops the zero off thinking it is a number not text. How can I keep Excel
from dropping the 0 off?
 
Hi,
Try changing the file extenstion to .txt When you import
the file, set the column with the PO numbers to text
 
This works, thanks

mzehr said:
Hi,
Try changing the file extenstion to .txt When you import
the file, set the column with the PO numbers to text
Click to expand...
 
You must log in or register to reply here.

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

How to stop Excel from automatically truncating leading zeros 2
Leading Zero dropping off after export to Excel 3
IF function results to include both text and cell value 2
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
How do I create a purchase order log in Excel? 1
csv format drops ending zeros 2
convert number to text without losing zeroes 20
SUMIF or SUMPRODUCT or ?? 2

Back
Top