0number

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Hi all, I know its not really related to vb, but its fairly simple. How I
make a number in a cell always be 3 digits long, or how do I make it so that
when a value like 9 is entered it changes to 009 or 045 etc.
Dave
 
Hi
if only the display is relevant use a custom format such as
000
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Macro storing as a date? 11
How to break up a cell with 3 embedded (new line characters) value 1
Time issues in code 6
Code to insert a coma 26
Cell Count Between Value 13
Text Formats 4
Optional argument as Variant not acting like number 4

Back
Top