number format

J

Jo

Hi
How do I change/create a number format to show 00005
instead of 5? I want to use this with a control box
output so '00005 would not work.
Thanks very much
Jo
 
K

Kirk

If you change the format of the cell to TEXT, then
whatever you input into the cell will be reflected.
It'll also still allow you to run any calculations that
you need to do as well.

Hope this helps.

Kirk
 
B

Bob Phillips

Jo,

Not sure what you mean by a control box, but if you format a number with a
custom format of 00000 it will show as you say, but will still be 5, and you
might need to format the target as FORMAT(number,"00000")
 

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

generate serial numbers and date it entered 3
Countdown macro - display settings 2
Paragraph numbering in Word 1
Excel does not accept text format! 0
How can the font and size of (all) citation numbers be altered? 1
How to extract rows according to a maximum for a column 3
Inconsistent formatting of section numbers 0
Finding the right style field in VBA 0

Top