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.
