How to set format cell as Number

[GilbertoLopez]

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.

[Deep.Shah · Accepted solution]

Try using ""0

[GilbertoLopez]

Thanks! That works fine!

[BenScholefield]

Hi, 

What would be the parameter for a Date format please? 

Thanks!

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

[LeonardoSQueiroz]

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

[ArunkumarManoha]

Hi, 

What would be the parameter for a Accounting format please? 

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

[Mhgirl]

Hello 

i need help for blueprism using 

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