tahirih
asked on
Find and Custom Formatting in Excel
Why is it when I have custom formatted a column in excel 2010 to be '00###' I cannot find 01003. I do understand that in this case, the original cell was 1003, but under this formatting, Excel nicely matched the total number of # signs (instead of forcing two xeros in the front).
Hope this made sense.
Thank you.
Hope this made sense.
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The definition of 0 and # in excel's help file:
Format Symbol Description/result
-------------------------- ---------- ---------- ---------- ---------- ------
0 Digit placeholder. For example, if you type 8.9 and
you want it to display as 8.90, then use the
format #.00
# Digit placeholder. Follows the same rules as the 0
symbol except Excel does not display extra zeros
when the number you type has fewer digits on either
side of the decimal than there are # symbols in the
format. For example, if the custom format is #.## and
you type 8.9 in the cell, the number 8.9 is
displayed.
Regards,
Curt
Format Symbol Description/result
--------------------------
0 Digit placeholder. For example, if you type 8.9 and
you want it to display as 8.90, then use the
format #.00
# Digit placeholder. Follows the same rules as the 0
symbol except Excel does not display extra zeros
when the number you type has fewer digits on either
side of the decimal than there are # symbols in the
format. For example, if the custom format is #.## and
you type 8.9 in the cell, the number 8.9 is
displayed.
Regards,
Curt
ASKER