| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to keep the zero on left without disappearing like 01234
How to keep the zero on left without disappearing like 0123454
In scanning software requires us to use excel .but in excel every time I scan a barcode with a zero in the beginning it disappear automatically |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to keep the zero on left without disappearing like 01234
Format the cell as text beforehand.
Pete |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to keep the zero on left without disappearing like 01234
Would a custom number format work for you?
Format/Cells/Custom 0000000 "emcsquare" wrote: How to keep the zero on left without disappearing like 0123454 In scanning software requires us to use excel .but in excel every time I scan a barcode with a zero in the beginning it disappear automatically |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to keep the zero on left without disappearing like 01234
For a cell, the formula =TEXT(A1+A2,"00000") will allow a calculation and retain the leading zero. -- JMB Wrote: Would a custom number format work for you? Format/Cells/Custom 0000000 "emcsquare" wrote: How to keep the zero on left without disappearing like 0123454 In scanning software requires us to use excel .but in excel every time I scan a barcode with a zero in the beginning it disappear automatically -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=529853 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel should calculate exponentials properly (right to left) | Excel Worksheet Functions | |||
| My columns run from right to left instead of left to right. Help? | Setting up and Configuration of Excel | |||
| Working days left in the month compared to previous months | Excel Worksheet Functions | |||
| Cell Borders and "Columns to Repeat at Left" | Excel Discussion (Misc queries) | |||
| The left function does not work when displaying times, how is thi. | Excel Worksheet Functions | |||
Hybrid Mode
