| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to add character zero in text string
i have a list of numbers inside sheet in one column, how can i add
character zero inside every field in fornt of number, and do it automaticly? can saomeon help pleas i am new to excel |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to add character zero in text string
check out the cell format, go to format cells numbers tab, custom, in
the window type in "0"#### press ok and see what happens |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to add character zero in text string
On 20 Oct 2005 07:54:01 -0700, damorrison wrote:
check out the cell format, go to format cells numbers tab, custom, in the window type in "0"#### press ok and see what happens i dont know how to thank you enaugh :) thank you so much you help me alot |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add a character to the middle of a text string | Excel Discussion (Misc queries) | |||
| Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
| Remove last character of text string | Excel Worksheet Functions | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
Linear Mode
