| 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. |
| 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 | |||
Threaded Mode
