| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
add 0 i astored many of numbers
i need to add 0 in the beginig of each noumer in a colum
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
add 0 i astored many of numbers
Format the cells, got to custom format.
Use: 0###### Just make sure you use enough #'s to cover the longest number. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "mohamed gomaa" wrote: i need to add 0 in the beginig of each noumer in a colum |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
add 0 i astored many of numbers
Hi,
If you really need it added, not just displayed, then ="0"&A1 Copy down as far as necessary. Assumes the numbers are in column A. This formula makes them Text. If this helps, Please click the Yes button Cheers, Shane "mohamed gomaa" wrote: i need to add 0 in the beginig of each noumer in a colum |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Formula - Add column of numbers but ignore negative numbers | Excel Worksheet Functions | |||
| VLOOKUP should compare numbers stored as text to plain numbers. | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| convert negative numbers to positive numbers and vice versa | Excel Worksheet Functions | |||
Linear Mode
