ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Need a ZERO as the first character in a cell (https://www.excelbanter.com/new-users-excel/52999-need-zero-first-character-cell.html)

Mr_Jim

Need a ZERO as the first character in a cell
 
How do you make the first number in a string of numbers a zero and keep it
there?

RagDyeR

Need a ZERO as the first character in a cell
 
Depends on if you want a *true* number, or a text number.

For Text, precede the entry with an apostrophe ( ' ),
OR, pre-format the cell as text.

For true numbers, custom format the cell with the number of digits you're
using:

00000

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Mr_Jim" wrote in message
...
How do you make the first number in a string of numbers a zero and keep it
there?



damorrison

Need a ZERO as the first character in a cell
 
go to
format,cells,numbers,custom- in custom box type "0"####



All times are GMT +1. The time now is 06:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com