ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   VBA write macro change column with 3 number digits to 4 digits the (https://www.excelbanter.com/excel-discussion-misc-queries/254294-vba-write-macro-change-column-3-number-digits-4-digits.html)

James C[_2_]

VBA write macro change column with 3 number digits to 4 digits the
 

--
James

Jacob Skaria

VBA write macro change column with 3 number digits to 4 digits the
 
Do you mean

Sub Macro()
Range("D1:D10").NumberFormat = "0000"
End Sub

--
Jacob


"James C" wrote:


--
James


Pete_UK

VBA write macro change column with 3 number digits to 4 digitsthe
 
Use the white space (here) to record details of your requirements -
don't try to put it all in the message header.

Pete

On Jan 25, 1:51*pm, James C wrote:
--
James



James C[_2_]

VBA write macro change column with 3 number digits to 4 digits
 
Thanks for your response
--
James


"Jacob Skaria" wrote:

Do you mean

Sub Macro()
Range("D1:D10").NumberFormat = "0000"
End Sub

--
Jacob


"James C" wrote:


--
James



All times are GMT +1. The time now is 07:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com