formula
 

i want to put zero (0) before any given number like038388

formula
 

Format cell - Number tab, custom format. Input:
"0"#
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"vishal" wrote:

i want to put zero (0) before any given number like038388

formula
 

Check your earlier post.

vishal wrote:

i want to put zero (0) before any given number like038388

--

Dave Peterson

formula
 

Hi,
Suppose your number is in cell A1 in B1 enter

="0"&A1

copy the formula down

if this helps click yes, thanks

"vishal" wrote:

i want to put zero (0) before any given number like038388