| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3 zero instead 1 zero
hello dear,
i want type 1 zero in excel and type 3 zero instead 1 zero. what can i do? thanks for your help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
3 zero instead 1 zero
Hi,
It depends what you want them for. If you only want to see 3 zeroes format the cell with a custom format of 000 (that's 3 zeroes) Mike "javadez" wrote: hello dear, i want type 1 zero in excel and type 3 zero instead 1 zero. what can i do? thanks for your help. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
3 zero instead 1 zero
javadez;342000 Wrote: hello dear, i want type 1 zero in excel and type 3 zero instead 1 zero. what can i do? thanks for your help. Just go in Format Cell Number Custom and on right side type 000 Now whenever you will enter any single value like 1, 1 it will be displayed by 001, 002 -- mubashir aziz ------------------------------------------------------------------------ mubashir aziz's Profile: http://www.thecodecage.com/forumz/member.php?userid=237 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=95660 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
