| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display zeros to the left of a number
Good Morning,
how can i display the zeros to the left of a number? by the way i want the format of the field to be a number because i have a macro that validates the value entered in the field is a number. thank you very much |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display zeros to the left of a number
Use a format of 000000 or however many digits you want displayed.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Student" wrote in message ... Good Morning, how can i display the zeros to the left of a number? by the way i want the format of the field to be a number because i have a macro that validates the value entered in the field is a number. thank you very much |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display zeros to the left of a number
how do i do that?
"Bob Phillips" wrote: Use a format of 000000 or however many digits you want displayed. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Student" wrote in message ... Good Morning, how can i display the zeros to the left of a number? by the way i want the format of the field to be a number because i have a macro that validates the value entered in the field is a number. thank you very much |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display zeros to the left of a number
Right-click the cells in question, then choose "Format Cells" then click
"Custom" and type 000000 (as many zero's as you need) -- Charles Chickering "A good example is twice the value of good advice." "Student" wrote: how do i do that? "Bob Phillips" wrote: Use a format of 000000 or however many digits you want displayed. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Student" wrote in message ... Good Morning, how can i display the zeros to the left of a number? by the way i want the format of the field to be a number because i have a macro that validates the value entered in the field is a number. thank you very much |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display zeros to the left of a number
Hi,
via menu : Format/Cells ( or CTLR + 1 key combination) Select the Number Tab In Category , select Custom In Type, type the number of zero required eg : 00 = for 1 shows 01 000 for 22 shows 022 Regards JY "Student" wrote in message ... how do i do that? "Bob Phillips" wrote: Use a format of 000000 or however many digits you want displayed. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Student" wrote in message ... Good Morning, how can i display the zeros to the left of a number? by the way i want the format of the field to be a number because i have a macro that validates the value entered in the field is a number. thank you very much |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Zeros Display On Chart | Excel Discussion (Misc queries) | |||
| how to get left side zeros to show i.e. 00045 | Excel Discussion (Misc queries) | |||
| If number in cell does not equal 6 digits, add zeros to the left | Excel Discussion (Misc queries) | |||
| Essbase: Text zeros to number zeros | Excel Discussion (Misc queries) | |||
| Number format than does not display zeros after the deciaml point | Excel Discussion (Misc queries) | |||
Linear Mode
