![]() |
Displaying a zero
I had a column of numbers with dashes in between like this 08-188-22-33-0044.
I found and edited out the dashes so it looks like 818822330044. The problem is that it removed the zeros at the beginning of the number and I can't get them to display. |
Displaying a zero
hi
to display leading zeros, you have to formate the number as text or lead it with an apostophe. You can create a custom format to display a leading zero on the screen but in the formula bar, it will not have the leading zero. and if you copy, paste or export.....no leading zero. formating does not change data, it just changes the way it looks on the screen. regards FSt1 "Tommy Kramer 9" wrote: I had a column of numbers with dashes in between like this 08-188-22-33-0044. I found and edited out the dashes so it looks like 818822330044. The problem is that it removed the zeros at the beginning of the number and I can't get them to display. |
Displaying a zero
=SUBSTITUTE(A2,"-","")
-- David Biddulph "Tommy Kramer 9" wrote in message ... I had a column of numbers with dashes in between like this 08-188-22-33-0044. I found and edited out the dashes so it looks like 818822330044. The problem is that it removed the zeros at the beginning of the number and I can't get them to display. |
Displaying a zero
Add an apostrophe before the leading 0 before doing your EditReplace or
whatever editing you used. Or if all numbers the same length, Custom Format to 0000000000000 Gord Dibben MS Excel MVP On Tue, 15 Jan 2008 13:57:01 -0800, Tommy Kramer 9 wrote: I had a column of numbers with dashes in between like this 08-188-22-33-0044. I found and edited out the dashes so it looks like 818822330044. The problem is that it removed the zeros at the beginning of the number and I can't get them to display. |
All times are GMT +1. The time now is 07:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com