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

How to insert/add zero before a format of number
Pdf and xps add in 2007 - Download - Other
How to insert a tick on word - Guide
How to add @ in laptop - Guide
Excel date format dd.mm.yyyy - Guide
How to insert a line in word for resume - Guide

1 response

Answer 1 / 1

xpcman Posts 19530 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 1,826
Nov 3, 2014 at 07:48 PM

can't you just apply a custom format something like 9999.9999

Subscribe To Our Newsletter!