Change format excel?

I want to change format in column FPP (Use Column Name) to number.

From
image

To
image

Please guide me for solve it.

Hi @fairymemay

Have a look on the document

Refer this thread

Regards
Gokul

@Gokul001 i don’t want select column by ALPHABET but I want fix with column Name.

Please guide me for solve it.

Hi @fairymemay

You can try invoking a VBA.

see this post

Thanks,
Prankur

@PrankurJoshi From your suggest it use Range B1:B20.

But I don’t fix column B ( I want use column Name(header name))

please guide me for edit it.

Hi @fairymemay

try this above activity , this will help you

Thanks

1 Like