Typeing zero as first number of a string

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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)
 
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

Need 7 digit number with differnt number of leading zeros 10
Adding 0 to the front of a number 4
how to display zero prefixes in worksheet cells such as phone numb 1
In Excel find 5 digit number and replace with leading zero 2
How do I stop Excel from dropping leading zeros? 9
Lead Zeros in Text 6
How to merge Excel address columns when some zips begin with zeros 4
Another Leading Zero Question 7

Back
Top