Software

Ask something
Discussion Locked

Excel

0 helpful
4 replies

by vixiin

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to create a formula that adds a zero to the front of pre existing text. How can I accomplish this.

Kindest regards

4 replies

by anthonyz

If it is for text, you could try [=" 0 "&B1] where B1 is the cell you want to add the zero to... I'm not sure if it would work for what you're trying to do... hope it helps... good luck...

Tony

by nsohenick

If the text is actually a number the zero will be suppressed. You would have to change the format to text and then enter this formula in the cells next to it. Assuming your text is in A1.

=CONCATENATE("0" + A1)

by gdhar_in

There is a very simple solution. Simply add apostrophe and then type the no. with zero or zeroes in the beginning. But take care the no. becomes text. You've to convert into no. again while refering to it.

This discussion is closed to new replies.