How to insert/add zero before a format of number [Closed]

Report
Posts
1
Registration date
Thursday October 30, 2014
Status
Member
Last seen
October 30, 2014
-
Posts
19542
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
-
i have an excel sheet in which column A contains value like
a)1344.0001,
b)1344.001,
c)344.001,
d)1344
i want all my information to be in 0000.0000 format.
if i want to add "0" in b) 1344.0010
c)0344.0010

,that is in front or end to complete 0000.0000 how to write code, i am very new to VBA.

Thnx in advance

1 reply

Posts
19542
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,660
can't you just apply a custom format something like 9999.9999

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!