| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get the mid function to work with a zero
There is not enough detail to determine what is going wrong. Can you post the formulae or code that you are using. My guess is that you have a number in a cell which is formatted 000000 (or however many zeros) rather than a text string. This is one way that would give the results you observe. If you use =MID(RIGHT("0000"&D1,4),1,1) where the 4 is the length of the barcode you should be ok. The "0000" needs to be long enough to cater for the maximum number of leading zeros regards -- tony h ------------------------------------------------------------------------ tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074 View this thread: http://www.excelforum.com/showthread...hreadid=548914 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why won't EDATE function work in Excel? | Excel Worksheet Functions | |||
| What would cause the sum function in a column not to work? | Excel Discussion (Misc queries) | |||
| HOW DO YOU MAKE FORECAST FUNCTION WORK IN EXCEL? | Excel Worksheet Functions | |||
| Can't get SUM function to work in Excel 2000 | New Users to Excel | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Threaded Mode
