**Question description:**

*This user has given permission to use the problem statement for this
blog.*

I have a spread sheet with a column of existing numbers. I want to insert two zeros 00 in front of each number?

Solved by X. H. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user
information.

Excelchat Expert
19/03/2018 - 04:07

Hi

Excelchat Expert
19/03/2018 - 04:07

welcome to got it pro

User
19/03/2018 - 04:07

hello

Excelchat Expert
19/03/2018 - 04:08

if i get clearly you have set of numbers and you want to insert 00 in front of each number

Excelchat Expert
19/03/2018 - 04:08

am i right?

User
19/03/2018 - 04:08

yes

Excelchat Expert
19/03/2018 - 04:09

see cell B

Excelchat Expert
19/03/2018 - 04:09

i have done that for you

Excelchat Expert
19/03/2018 - 04:09

does this help?

Excelchat Expert
19/03/2018 - 04:09

kindly let me know if this helps

User
19/03/2018 - 04:10

how did u do it?

Excelchat Expert
19/03/2018 - 04:10

i concatenated 00 in front of numbers

Excelchat Expert
19/03/2018 - 04:10

"00"&A1

Excelchat Expert
19/03/2018 - 04:10

with & function we can concatenate

Excelchat Expert
19/03/2018 - 04:11

do you get this?

User
19/03/2018 - 04:11

how

Excelchat Expert
19/03/2018 - 04:11

see column C

Excelchat Expert
19/03/2018 - 04:11

i have concatenated many others along with 00 to help you

Excelchat Expert
19/03/2018 - 04:12

does that help?

Excelchat Expert
19/03/2018 - 04:12

do you get it?

Excelchat Expert
19/03/2018 - 04:13

please do give good rating

Excelchat Expert
19/03/2018 - 04:13

it really helps

Excelchat Expert
19/03/2018 - 04:13

please try and let me know if you face any issues

Excelchat Expert
19/03/2018 - 04:13

by using & function number gets converted to text

Excelchat Expert
19/03/2018 - 04:13

so we are able to see 001

Excelchat Expert
19/03/2018 - 04:14

do you get it?

User
19/03/2018 - 04:14

would you do it again slowly whilst I watch please

Excelchat Expert
19/03/2018 - 04:15

sure

Excelchat Expert
19/03/2018 - 04:15

see column E

User
19/03/2018 - 04:15

yes

Excelchat Expert
19/03/2018 - 04:15

did you see?

Excelchat Expert
19/03/2018 - 04:16

="00"&A1

Excelchat Expert
19/03/2018 - 04:16

use 00 in " "

Excelchat Expert
19/03/2018 - 04:16

so that it can be joined with A1 cell

Excelchat Expert
19/03/2018 - 04:16

do you get ?

Excelchat Expert
19/03/2018 - 04:17

does it help you ?

User
19/03/2018 - 04:18

a user has restricted the values?

Excelchat Expert
19/03/2018 - 04:18

which user?

Excelchat Expert
19/03/2018 - 04:18

it is simple formula

Excelchat Expert
19/03/2018 - 04:19

just join "00" with cell A1 using & function

Excelchat Expert
19/03/2018 - 04:19

try on your own

User
19/03/2018 - 04:19

I did and I received a message saying that a user has restricted the values

User
19/03/2018 - 04:19

it is somebody elses spreadsheet

Excelchat Expert
19/03/2018 - 04:20

i dont think it should happen

Excelchat Expert
19/03/2018 - 04:20

try on excel on your pc

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user
information.*