Home |
Search |
Today's Posts |
#1
|
|||
|
|||
showing a zero
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 |
#2
|
|||
|
|||
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" wrote in message ... 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 |
#3
|
|||
|
|||
Thanks Alan,
as the old saying goes - it's easy when you know how ! kgm "Alan" wrote in message ... 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" wrote in message ... 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 |
#4
|
|||
|
|||
Your welcome, stay on these groups, its where I learnt 90% of what I know,
Regards, Alan. "kgm" wrote in message ... Thanks Alan, as the old saying goes - it's easy when you know how ! kgm "Alan" wrote in message ... 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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel opens saved workbook without tabs or scroll bars showing? | Excel Worksheet Functions | |||
Data not showing on my chart | Charts and Charting in Excel | |||
Showing Duplicate Rows | Excel Discussion (Misc queries) | |||
formula in cell not showing result | Excel Worksheet Functions | |||
Bar showing value for missing data | Charts and Charting in Excel |