00's at the beginning of a number in Excel

N

newc

New Member
Joined
Nov 13, 2007
Messages
2
How can I type a number with zeros in front ie 00345 and save sheet as a CSV keeping the 00's showing. I have made the cell a text cell which works fine in Excel but when I save as a CSV file it changes and the zeros disappear.
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Sort by date Sort by votes
You can leave it as a number, you just need to put a ' before the number for example '001954

Give that a go, not sure how it will work when changed to csv
 
Upvote 0
Have tried your solution which is fine when saving as an Excel file but as soon as you save as a CSV file it changes and the zeros disappear.
 
Upvote 0
Hi Chris,

First, change the Format of the cells to TEXT. Then enter all the data with prefixed zeros. Next, Save the File with the "save as type": Text(Tab Delimited Text) in the dropwon available in File - Save As option.

When you open the file in Notepad it will have all the prefixed zeros.

PS: When you want to open the File in Excel then you just need to change the extension of the file to ".xls".
 
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
524
bkeebaugh
B
Y
  • Question
Unwanted empty rows in csv file
2
Replies
11
Views
870
Alex Blakenburg
A
M
  • Question
VBA to Clean Up CSV with Large Blank Spaces and Extra Text Rows
Replies
5
Views
418
kevin9999
K
Q
  • Question
how to edit this macro to export to desktop regardless of user?
Replies
3
Views
465
Radoslaw Poprawski
R
B
  • Solved
Changing from .CSV file type to .xlsx with VBA
Replies
3
Views
816
Domenic
D

Forum statistics

Threads
1,215,032
Messages
6,122,770
Members
449,095
Latest member
m_smith_solihull

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