Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get leading zeros using DEC2BIN
I have a range formatted as 00000000. When I type 354 in a cell, I get
00000354 as expected. No problem. When I use the Analysis Pak function = DEC2BIN(1), I get 1 instead of the desired 00000001. A different function for example =SUM(1, 5) works as expected and gives me 00000006. How can I do this without VBA? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get leading zeros using DEC2BIN
Use either =--dec2bin(1)
or =dec2bin(1)*1 Then the formating will hold. -- Gary''s Student "scallyte" wrote: I have a range formatted as 00000000. When I type 354 in a cell, I get 00000354 as expected. No problem. When I use the Analysis Pak function = DEC2BIN(1), I get 1 instead of the desired 00000001. A different function for example =SUM(1, 5) works as expected and gives me 00000006. How can I do this without VBA? Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get leading zeros using DEC2BIN
How about
=DEC2BIN(1,8) From Help: Syntax: DEC2BIN(number,places) ... Places is the number of characters to use. If places is omitted, DEC2BIN uses the minimum number of characters necessary. Places is useful for padding the return value with leading 0s (zeros). In article .com, "scallyte" wrote: I have a range formatted as 00000000. When I type 354 in a cell, I get 00000354 as expected. No problem. When I use the Analysis Pak function = DEC2BIN(1), I get 1 instead of the desired 00000001. A different function for example =SUM(1, 5) works as expected and gives me 00000006. How can I do this without VBA? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spliting a number with leading zeros | Excel Discussion (Misc queries) | |||
CSV File - Leading Zeros | Excel Discussion (Misc queries) | |||
How do I force leading zeros in an Excel cell? | Excel Discussion (Misc queries) | |||
Leading zeros | Excel Discussion (Misc queries) | |||
save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) |