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 19528 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 - Nov 3, 2014 at 07:48 PM
xpcman Posts 19528 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
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:
- How to insert/add zero before a format of number
- How to add songs to sound picker - Guide
- 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
- How to add @ in laptop - Guide
- How to insert a checkmark in word - Guide
- How to add someone on messenger with phone number - Guide
1 response
xpcman
Posts
19528
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,824
Nov 3, 2014 at 07:48 PM
Nov 3, 2014 at 07:48 PM
can't you just apply a custom format something like 9999.9999
