| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
i want to put zero (0) before any given number like038388
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula
Check your earlier post.
vishal wrote: i want to put zero (0) before any given number like038388 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
