Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need a ZERO as the first character in a cell
How do you make the first number in a string of numbers a zero and keep it
there? |
#2
|
|||
|
|||
Need a ZERO as the first character in a cell
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" wrote in message ... How do you make the first number in a string of numbers a zero and keep it there? |
#3
|
|||
|
|||
Need a ZERO as the first character in a cell
go to
format,cells,numbers,custom- in custom box type "0"#### |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying cell names | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
How can I search for more than one text character in a cell? | Excel Worksheet Functions | |||
Cell 255 character limit and formula | Excel Worksheet Functions | |||
Searching a cell for a certain character. | Excel Worksheet Functions |