Typeing zero as first number of a string

G

Guest

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?
 
G

Guest

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)
 
G

Guest

Many, Many THANX ! !

engeebee

john the confused said:
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)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

In Excel find 5 digit number and replace with leading zero 2
How to merge Excel address columns when some zips begin with zeros 4
last number defaluts to zero 2
How to Combine two cells (numbers) but not add 7
12 digit number rounding down why? 5
A zero as a first digit 3
getting the zero digit to show in a cell e.g. 0456 3
Microsoft Excel will not show a "zero" as the first digit spot. 1

Top