Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I type number that begins with a zero to keep zero?
I am typing last four digits of social in cells and ones that begin with
zero, will not hold the zero. How do if fix this? thanks Vickie Newto |
#2
|
|||
|
|||
Format the cell as Custom and under the "Type" section type 0000.
HTH |
#3
|
|||
|
|||
Format the cells as "Text".... Format-Cells-Click on "Text"
-- Regards, Dave <!-- "Vickie Newton" wrote: I am typing last four digits of social in cells and ones that begin with zero, will not hold the zero. How do if fix this? thanks Vickie Newto |
#4
|
|||
|
|||
Give the cell(s) a custom format of 0000.
Format the cells as text, then type your entry. Start your entry with a leading apostrophe: '0012 The first one will keep the value numeric. The bottom two will treat your value as text. Vickie Newton wrote: I am typing last four digits of social in cells and ones that begin with zero, will not hold the zero. How do if fix this? thanks Vickie Newto -- Dave Peterson |
#5
|
|||
|
|||
Hi! Format the cell as text before you fill it. Use Format Cells...NumberText. It won't be a number anymore, but I can't imagine you want to calculate using it... Alf -- AlfD ------------------------------------------------------------------------ AlfD's Profile: http://www.excelforum.com/member.php...fo&userid=4785 View this thread: http://www.excelforum.com/showthread...hreadid=468922 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting a number to Excel that begins with 0 | Excel Discussion (Misc queries) | |||
Number of labels on X-axis one more than number of values on Y-axi | Charts and Charting in Excel | |||
"AutoPrint" type macro requires tweaking | Excel Discussion (Misc queries) | |||
look up number in column | Excel Worksheet Functions | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) |