How do you make the first number in a string of numbers a zero and keep it
there?
How do you make the first number in a string of numbers a zero and keep it
there?
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" <[email protected]> wrote in message
news:[email protected]...
How do you make the first number in a string of numbers a zero and keep it
there?
go to
format,cells,numbers,custom- in custom box type "0"####
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks