# Excel - COLUMN Function Problem - Expert Solution

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
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
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
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
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
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.