| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
zero "0" dropping from the beginning of my serial numbers
How can I get my serial numbers that begin with "0" to not drop off the zero
in a cell of a spreadsheet? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
zero "0" dropping from the beginning of my serial numbers
On Dec 18, 4:25 pm, Elton Jones <Elton
wrote: How can I get my serial numbers that begin with "0" to not drop off the zero in a cell of a spreadsheet? Format the cell as text. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
zero "0" dropping from the beginning of my serial numbers
Format as text before you enter the data, or
Precede the data with an apostrophe to force it to be treated as text, or Format as 000000 if you want to show 6 digits including leading zeroes. -- David Biddulph "Elton Jones" <Elton wrote in message ... How can I get my serial numbers that begin with "0" to not drop off the zero in a cell of a spreadsheet? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
zero "0" dropping from the beginning of my serial numbers
format the cell as text
hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Elton Jones" escreveu: How can I get my serial numbers that begin with "0" to not drop off the zero in a cell of a spreadsheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| "Text to Columns" Conversion Dropping Cols | Excel Discussion (Misc queries) | |||
| anyone ever hear of a formula beginning "xlend"? | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Hybrid Mode
