| 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 |
| 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 | |||
Threaded Mode
