Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
Hi
you have basically three options: 1) if you want the number to be a number (ie you want to calculate with it later on) then you'll need to use a custom format, click on the cell, choose format / cells - under the numbers tab, choose custom, in the white line on the right hand side type either 00 (to display as 01) or 000 (to display as 001), click OK if you're happy for the 01 to be treated as text then 2) type '01 or '001 into the cell (note the apostraphe before the 0 - this makes it text but will not display nor print) or 3) format the cell as text (format / cells / on the numbers tab choose text) before typing the 01 or 001 into the cell. hope this helps Cheers JulieD "Vinayak" wrote in message ... I AM NOT ABLE TO ENTER THE NUMBER AS 01 OR 001-SUGGESTION PLEASE |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
multiply by actual number in cell | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
Convert week number into calendar month? | Excel Worksheet Functions |