ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Displaying a zero (https://www.excelbanter.com/excel-discussion-misc-queries/173141-displaying-zero.html)

Tommy Kramer 9[_2_]

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.

FSt1

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.


David Biddulph[_2_]

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.




Gord Dibben

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