Cell should show "0" as character....

[Divy]

..

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

 

[Guest]

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 = "@"

 

[DtTall]

You will need to format the cell as text.