cancel
Showing results for 
Search instead for 
Did you mean: 

How to set format cell as Number

Gilberto.lopez
Level 3
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.
1 BEST ANSWER

Helpful Answers

Deep.Shah
Level 6
6 REPLIES 6

Deep.Shah
Level 6
Try using ""0

Gilberto.lopez
Level 3
Thanks! That works fine!

Hi, 

What would be the parameter for a Date format please? 

Thanks!



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

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
------------------------------
Leonardo Soares RPA Developer América/Brazil

Hi, 

What would be the parameter for a Accounting format please? 



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

Hello 

i need help for blueprism using 



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