ExcelBanter - Typeing zero as first number of a string

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Typeing zero as first number of a string (https://www.excelbanter.com/excel-discussion-misc-queries/129615-typeing-zero-first-number-string.html)

engeebee

Typeing zero as first number of a string

How do I get the zero (o) to appear on screen and print when I have a 5 digit
number and zero is the first digit?

Teethless mama

Typeing zero as first number of a string

format cell as: 00000

"engeebee" wrote:

How do I get the zero (o) to appear on screen and print when I have a 5 digit
number and zero is the first digit?

john the confused

Typeing zero as first number of a string

type an ' then type in the number like '00000 This will treat the number as
text
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

"engeebee" wrote:

How do I get the zero (o) to appear on screen and print when I have a 5 digit
number and zero is the first digit?

engeebee

Typeing zero as first number of a string

Many, Many THANX ! !

engeebee

"john the confused" wrote:

type an ' then type in the number like '00000 This will treat the number as
text
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

"engeebee" wrote:

How do I get the zero (o) to appear on screen and print when I have a 5 digit
number and zero is the first digit?

All times are GMT +1. The time now is 04:37 AM.