How to insert/add zero before a format of number

Closed
anuph Posts 1 Registration date Thursday 30 October 2014 Status Member Last seen 30 October 2014 - 30 Oct 2014 à 17:36
xpcman Posts 19528 Registration date Wednesday 8 October 2008 Status Contributor Last seen 15 June 2019 - 3 Nov 2014 à 19:48
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
Related:

1 response

xpcman Posts 19528 Registration date Wednesday 8 October 2008 Status Contributor Last seen 15 June 2019 1,824
3 Nov 2014 à 19:48
can't you just apply a custom format something like 9999.9999