Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excell deletes 0 when its the first number in a string
Anyone know how I can turn off the option that deletes 0 when its the first
number in a string? everytime I tyoe in a number such as 0987 it deletes the 0 at the begining. |
#2
|
|||
|
|||
Either pre-format the cell as TEXT, or type an apostrophe before the leading
zero...........the apostrophe will not be seen in the cell or printout, but will format that cell as TEXT.......... Vaya con dios, Chuck, CABGx3 "dustin1138" wrote in message ... Anyone know how I can turn off the option that deletes 0 when its the first number in a string? everytime I tyoe in a number such as 0987 it deletes the 0 at the begining. |
#3
|
|||
|
|||
Dustin
Format the cell as text *before* entering data (FormatCells...Text) or pre-fix the data with ' (single apostrophe) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "dustin1138" wrote in message ... Anyone know how I can turn off the option that deletes 0 when its the first number in a string? everytime I tyoe in a number such as 0987 it deletes the 0 at the begining. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
how do i convert the number 1 as 01 or 001 in excell cell | Excel Worksheet Functions | |||
How do I get excell to indicate when a number is out of a set ran. | Excel Worksheet Functions | |||
I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |