V
vishal
i want to put zero before any number means 025652 like this
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
Luke M
Custom format of
"0"#
will work.
"0"#
will work.
D
Dave Peterson
Maybe you can use a custom number format.
Select the range (entire column???)
In xl2003 menus:
Format|Cells|number tab|custom category
000000
Select the range (entire column???)
In xl2003 menus:
Format|Cells|number tab|custom category
000000
R
Roachy
Vishal,
Not sure if there is an easier way but I would simply create another column
with "0" in and then concatenate the 0 with you number eg:
CELL A1: 0
CELL A2: 25652
CELL A3: =concatenate(A1,A2) this would return 025652
is this what your looking for???
Not sure if there is an easier way but I would simply create another column
with "0" in and then concatenate the 0 with you number eg:
CELL A1: 0
CELL A2: 25652
CELL A3: =concatenate(A1,A2) this would return 025652
is this what your looking for???
D
David Biddulph
Yes, there is an easier way. If you want to use concatenation, you don't
need to put 0 in A1. You could use =CONCATENATE(0,A2), or just =0&A2.
need to put 0 in A1. You could use =CONCATENATE(0,A2), or just =0&A2.