Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Zeros in cells
I'm importing some data in which a number of the cells contain numbers that
begin with mulitple zeroes, but excel is autmoatically deleting those zeroes. Formatting the cells to zip code format helps with some of the numbers but not all. For example 00043994267 becomes 43994267 and I need the zero in the beginning Any ideas mhogan |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Zeros in cells
Pre-format your cells as Text, then Copy and Paste
or Custom format cells as: 00000000000 "mhogan" wrote: I'm importing some data in which a number of the cells contain numbers that begin with mulitple zeroes, but excel is autmoatically deleting those zeroes. Formatting the cells to zip code format helps with some of the numbers but not all. For example 00043994267 becomes 43994267 and I need the zero in the beginning Any ideas mhogan |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Zeros in cells
In addition to t.m's comments...If you are using the Excel Import Wizard,
tell the Wizard that the field is Text -- Gary's Student "mhogan" wrote: I'm importing some data in which a number of the cells contain numbers that begin with mulitple zeroes, but excel is autmoatically deleting those zeroes. Formatting the cells to zip code format helps with some of the numbers but not all. For example 00043994267 becomes 43994267 and I need the zero in the beginning Any ideas mhogan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sum of blank cells returns zeros | Excel Worksheet Functions | |||
Calculating only non-empty cells... | Excel Worksheet Functions | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |