| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get the mid function to work with a zero
try to format the cell as a text.
regards from Brazil Marcelo "garbold" escreveu: Hi all I am trying to extract numbers from a test string using the MID function,all is well until the text string starts with a zero.This is then ignored and uses the next available number.It is for a barcode generator so the zero is required. thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i get the mid function to work with a zero
Hi thanks have tried that and now it works thanks again
"Marcelo" wrote: try to format the cell as a text. regards from Brazil Marcelo "garbold" escreveu: Hi all I am trying to extract numbers from a test string using the MID function,all is well until the text string starts with a zero.This is then ignored and uses the next available number.It is for a barcode generator so the zero is required. thanks |
| Reply |
| 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) | |||
Hybrid Mode
