| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell should show "0" as character....
..
Hi All..... I'm looking for entering values in the cells. The idea here is to display wht exactly is typed without using the hyphen " ' " key. Specifically, i wan to show "05'' as "05" only, but when typed, it shows "5".... Please revert ..... Regards, Divy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell should show "0" as character....
Divy,
One way is to format the cells as text. 1. Select the cell(s) 2. Format-Cells 3. In the Number Tab, under Category, select Text. If you're looking for a way to do this with VBA code, something like this will apply the Text format to the entire column A. Range("A:A").NumberFormat = "@" -- Hope that helps. Vergel Adriano "Divy" wrote: .. Hi All..... I'm looking for entering values in the cells. The idea here is to display wht exactly is typed without using the hyphen " ' " key. Specifically, i wan to show "05'' as "05" only, but when typed, it shows "5".... Please revert ..... Regards, Divy |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell should show "0" as character....
You will need to format the cell as text.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to show "yes" or "No" in a cell if certain criteria is met? | New Users to Excel | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| I need to count occurr. of the character "," in a single cell | Excel Worksheet Functions | |||
| if "a" selected from dropdown menu then show "K" in other cell | Excel Worksheet Functions | |||
| Pivot table "Group and Show Details" vs. "SubTotals" | Excel Programming | |||
Hybrid Mode
