Need a ZERO as the first character in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
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!
=====================================================

How do you make the first number in a string of numbers a zero and keep it
there?
 
Back
Top