..

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

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
>
>

You will need to format the cell as text.