How to insert/add zero before a format of number

Closed
anuph Posts 1 Registration date Thursday October 30, 2014 Status Member Last seen October 30, 2014 - Oct 30, 2014 at 05:36 PM
xpcman Posts 19532 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 - Nov 3, 2014 at 07:48 PM
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

xpcman Posts 19532 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 1,829
Nov 3, 2014 at 07:48 PM
can't you just apply a custom format something like 9999.9999
0