Zero formatting

J

jonah

New Member
Joined
Aug 11, 2003
Messages
9
Hi!
Importing a text file into excel and wants to keep all values the same as original format. Problem is that zeros are taken out, i.e 00 becomes 0, 009 becomes 9 etc. I tried using format/text both before and after importing the file without any luck. Textfile constists of long, continous text which I'm using excel to split up into columns.
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Sort by date Sort by votes
At Step 3 of the Text to Columns Wizard click the offending column and check Text under Column data format.
 
Upvote 0
If you are importing through the Excel import wizard, you have the capability of telling Excel the data format of the the fields you are importing (Step 3 of the import). For all the fields that you are bringing that you want to keep leading zeroes, bring them in as Text instead of General.
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question
Number format with 6 digits from import without leading zeros
Replies
4
Views
497
bkeebaugh
B
A
  • Solved
Pivot Table Slicers mystery!!!
Replies
9
Views
786
adambc
A
T
  • Solved
Copy worksheet to new workbook without formulas or macro button
Replies
9
Views
532
Tgrundy09
T
I
  • Question
Why text color change when double click.
Replies
0
Views
389
i200yrs
I
D
  • Question
Excel on Mac - file repair issues
Replies
1
Views
1K
dskills
D

Forum statistics

Threads
1,214,653
Messages
6,120,748
Members
448,989
Latest member
mariah3

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top