Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why do the preceding zeros disappear when I remove dashes?
I work with spreadsheets that contain list of numbers separated by dashes,
such as 001-117-251. I then have to copy these numbers into a software program that will not accept dashes, so I would like to remove them using the Find and Replace feature in Excel. However, when I do this any zeros at the beginning of the number vanish, and I end up with something like this: 1117251. How do I prevent the zeros from vanishing? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why do the preceding zeros disappear when I remove dashes?
It changes it to a number in which leading zeroes are suppressed.
Try formatting as '000000000'. It may lose them in the export, but try it and see. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "carridin1" wrote in message ... I work with spreadsheets that contain list of numbers separated by dashes, such as 001-117-251. I then have to copy these numbers into a software program that will not accept dashes, so I would like to remove them using the Find and Replace feature in Excel. However, when I do this any zeros at the beginning of the number vanish, and I end up with something like this: 1117251. How do I prevent the zeros from vanishing? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why do the preceding zeros disappear when I remove dashes?
If the export loses the leading zeroes, try using a helper column
=TEXT(A1,"000000000") -- David Biddulph "Bob Phillips" wrote in message ... It changes it to a number in which leading zeroes are suppressed. Try formatting as '000000000'. It may lose them in the export, but try it and see. "carridin1" wrote in message ... I work with spreadsheets that contain list of numbers separated by dashes, such as 001-117-251. I then have to copy these numbers into a software program that will not accept dashes, so I would like to remove them using the Find and Replace feature in Excel. However, when I do this any zeros at the beginning of the number vanish, and I end up with something like this: 1117251. How do I prevent the zeros from vanishing? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why do the preceding zeros disappear when I remove dashes?
That works, thanks guys!
"carridin1" wrote: I work with spreadsheets that contain list of numbers separated by dashes, such as 001-117-251. I then have to copy these numbers into a software program that will not accept dashes, so I would like to remove them using the Find and Replace feature in Excel. However, when I do this any zeros at the beginning of the number vanish, and I end up with something like this: 1117251. How do I prevent the zeros from vanishing? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to remove dashes | Excel Worksheet Functions | |||
How can SS#s be displayed as text with all zeros and no dashes? | Excel Discussion (Misc queries) | |||
How do I format fields to show preceding zeros? | Excel Discussion (Misc queries) | |||
HTML to Excel: preceding 0's disappear?! | Excel Discussion (Misc queries) | |||
Preceding Zeros... | Excel Worksheet Functions |