ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how to add character zero in text string (https://www.excelbanter.com/excel-programming/343347-how-add-character-zero-text-string.html)

Svemir

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

damorrison[_2_]

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


kozmos241

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


All times are GMT +1. The time now is 09:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com