Excel – Inserting zero in front of Number

If you already have the data entered as text, then you may need an intermediate formula to convert to the required format:


Assuming you have the A column formatted as text, you can then copy and paste values from the formulas back into your original column.

Quote by
SISINDOTEK – IT Training & Solution Provider
Jl. Sukasenang VI-6B Bandung – Jawa Barat 40124
Tel. 022-71242266 , SMS. 0812.8733.1966
info , YM. sisindotek
www.sisindotek.com , facebook.com/sisindotek , twitter.com/sisindotek


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s