Number Format in VBA
How to a force VBA to show an integer as a fixed number of digits? eg
display 240 as 0000240 |
Number Format in VBA
Set the format (FormatCellsCustom) to 0000000
-- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "PhilM" wrote in message oups.com... How to a force VBA to show an integer as a fixed number of digits? eg display 240 as 0000240 |
Number Format in VBA
Hi Phil
Assuming you want your variable myVar to hold this value: myVar = Format(240,"0000000") Note that this is held as a string value. If you simply want to display 240 in your sheet in the desired format, then you need to set the number format of the cell that holds the value: Range("A1").Value = 240 Range("A1").NumberFormat = "0000000" Hope this helps! Richard PhilM wrote: How to a force VBA to show an integer as a fixed number of digits? eg display 240 as 0000240 |
All times are GMT +1. The time now is 09:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com