I.T Solution | I.T Training | I.T Integration System

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


Single Post Navigation

Leave a Reply

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

You are commenting using your 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: