I want to show numbers beginning with 0 (zero) in a cell
e.g. 0123456.
Whenever I enter anything, I lose the zero.
Help please for a beginner!
kgm
I want to show numbers beginning with 0 (zero) in a cell
e.g. 0123456.
Whenever I enter anything, I lose the zero.
Help please for a beginner!
kgm
You can Format the cell as text, (Right click the cell, 'Format Cells' >
'Number' > check 'Text') before you enter the value, or prefix the number
with `
like '015472. The ` will show in the formula bar, but not in the cell. Note
that if you do this the number will be text, not a true number and certain
functions may not behave as expected'
Regards,
Alan.
"kgm" <[email protected]> wrote in message
news:[email protected]...
>I want to show numbers beginning with 0 (zero) in a cell
> e.g. 0123456.
> Whenever I enter anything, I lose the zero.
> Help please for a beginner!
>
> kgm
>
>
>
Thanks Alan,
as the old saying goes - it's easy when you know how !
kgm
"Alan" <[email protected]> wrote in message
news:[email protected]...
> You can Format the cell as text, (Right click the cell, 'Format Cells' >
> 'Number' > check 'Text') before you enter the value, or prefix the number
> with `
> like '015472. The ` will show in the formula bar, but not in the cell.
> Note that if you do this the number will be text, not a true number and
> certain functions may not behave as expected'
> Regards,
> Alan.
> "kgm" <[email protected]> wrote in message
> news:[email protected]...
>>I want to show numbers beginning with 0 (zero) in a cell
>> e.g. 0123456.
>> Whenever I enter anything, I lose the zero.
>> Help please for a beginner!
>>
>> kgm
>>
>>
>>
>
>
Your welcome, stay on these groups, its where I learnt 90% of what I know,
Regards,
Alan.
"kgm" <[email protected]> wrote in message
news:[email protected]...
> Thanks Alan,
> as the old saying goes - it's easy when you know how !
>
> kgm
> "Alan" <[email protected]> wrote in message
> news:[email protected]...
>> You can Format the cell as text, (Right click the cell, 'Format Cells' >
>> 'Number' > check 'Text') before you enter the value, or prefix the number
>> with `
>> like '015472. The ` will show in the formula bar, but not in the cell.
>> Note that if you do this the number will be text, not a true number and
>> certain functions may not behave as expected'
>> Regards,
>> Alan.
>> "kgm" <[email protected]> wrote in message
>> news:[email protected]...
>>>I want to show numbers beginning with 0 (zero) in a cell
>>> e.g. 0123456.
>>> Whenever I enter anything, I lose the zero.
>>> Help please for a beginner!
>>>
>>> kgm
>>>
>>>
>>>
>>
>>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks