Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I show a "0" before a series of numbers?
In excel I am trying to type 0123 but the 0 is not showing - What do I do?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I show a "0" before a series of numbers?
See if this works:
'format'...'cells'...'custom' in the little window below 'Type' put 0### format the cell 1st and then try typing 123 in the cell "Caryn Frank" wrote: In excel I am trying to type 0123 but the 0 is not showing - What do I do? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I show a "0" before a series of numbers?
"Caryn Frank" wrote: In excel I am trying to type 0123 but the 0 is not showing - What do I do? You can only show leading zeros in cells that are formatted as text because leading zeros have no meaning mathematically. Format the whole column or row as text and then enter whatever you need to. or Use a leading apostrophe (aka single quote) before the string with a leading zero, like this ... '0123 B+ HALinNY |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I show a "0" before a series of numbers?
Caryn
If you need don't need these as numbers for calculations pre-format the cells as text or precede each number with an apostrophe. If you need as numbers.....follow Tim's advice. Gord Dibben MS Excel MVP On Fri, 1 Dec 2006 08:18:03 -0800, Caryn Frank <Caryn wrote: In excel I am trying to type 0123 but the 0 is not showing - What do I do? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find missing numbers in series | Excel Worksheet Functions | |||
How to show all the possible combination of a set of numbers? | Excel Worksheet Functions | |||
How do I show break in bar graph to show large and small numbers | Charts and Charting in Excel | |||
How to change a series of positive numbers to negative numbers | Excel Worksheet Functions | |||
How to convert a series of numbers | Excel Worksheet Functions |