Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using LEFT, can excel produce the first 0's in a custom format?
I have a custom format (00000) on cell A1. The data is 00251. I have a
formula in B2 to read the first 3 digits in A1 (Left, A1, 3). How do I get B2 to pick up the data 002 instead of 251? Excel won't read the preceding 0's. |
#2
|
|||
|
|||
=LEFT(TEXT(A1,"00000"),3)
-- Kind Regards, Niek Otten Microsoft MVP - Excel "kanye" wrote in message ... I have a custom format (00000) on cell A1. The data is 00251. I have a formula in B2 to read the first 3 digits in A1 (Left, A1, 3). How do I get B2 to pick up the data 002 instead of 251? Excel won't read the preceding 0's. |
#3
|
|||
|
|||
The leading zeros aren't *really* there so far as values are concerned. Only
the illusion of leading zeros when you use a custom format Try =LEFT(TEXT(A1,"000000"),3) "kanye" wrote: I have a custom format (00000) on cell A1. The data is 00251. I have a formula in B2 to read the first 3 digits in A1 (Left, A1, 3). How do I get B2 to pick up the data 002 instead of 251? Excel won't read the preceding 0's. |
#4
|
|||
|
|||
=TEXT(LEFT(A10,LEN(A10)-2),"000")
-- HTH RP (remove nothere from the email address if mailing direct) "kanye" wrote in message ... I have a custom format (00000) on cell A1. The data is 00251. I have a formula in B2 to read the first 3 digits in A1 (Left, A1, 3). How do I get B2 to pick up the data 002 instead of 251? Excel won't read the preceding 0's. |
#5
|
|||
|
|||
Thanks to you both.
"kanye" wrote: I have a custom format (00000) on cell A1. The data is 00251. I have a formula in B2 to read the first 3 digits in A1 (Left, A1, 3). How do I get B2 to pick up the data 002 instead of 251? Excel won't read the preceding 0's. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions | |||
In only Excel, my mouse behaves as if the left button is held dow. | Excel Discussion (Misc queries) | |||
How do I produce a running Census report in Excel? | Excel Worksheet Functions | |||
In Excel can I move the tabs to the left side of the workbook? | Excel Worksheet Functions |