topic How to set format cell as Number in Product Forum

How to set format cell as Number

Gilberto.lopez — Fri, 18 Aug 2017 05:34:00 GMT

Hi Everybody! Can somebody help me? We Know that when we use the action "Format Cell" from MS Excel VBO we can change Cell Format. For example if we use "@" the format cell is going to be Text, but i want to know how or wich character i must to use to set format as Number. I Hope somebody can help me.

Try using ""0

Deep.Shah — Fri, 18 Aug 2017 09:01:00 GMT

Try using ""0

Thanks! That works fine!

Gilberto.lopez — Sat, 19 Aug 2017 04:18:00 GMT

Thanks! That works fine!

RE: Try using ""0

Ben_Scholefield_Everflow — Fri, 27 Oct 2023 10:21:00 GMT

Hi,

What would be the parameter for a Date format please?

Thanks!

------------------------------
Ben Scholefield
------------------------------

RE: Try using ""0

LeonardoSQueiroz — Sat, 28 Oct 2023 14:24:00 GMT

Hello Ben,

Try

DD/MM/aaaa
dd/MM/aa
dd-MM-aaaa
MM-dd-aa

Regards,

------------------------------
Leonardo Soares
RPA Developer Tech Leader
Bridge Consulting
América/Brazil
------------------------------

RE: Try using ""0

ArunkumarManoha — Wed, 29 Nov 2023 08:45:00 GMT

Hi,

What would be the parameter for a Accounting format please?

------------------------------
Arunkumar Manoharan
------------------------------

RE: Try using ""0

Mhgirl — Tue, 20 Feb 2024 19:27:00 GMT

Hello

i need help for blueprism using

------------------------------
Mh girl
------------------------------

Re: Try using ""0

jaypv — Wed, 30 Jul 2025 15:45:42 GMT

can someone give the full syntax to convert the column to number.. when i am using ""0 it is giving error and when i give "0" then its not working.. can u tell me the correct syntax