Write number in excel

Hello,

i would like to write numbers inside a workbook as a number and not as general value.

Does anyone knows how to do it?

Thanks

1 Like

Hi,
After Using Write cell activity follow the below steps…
By using Send hotkey activity you can change the value type to Number…
Like Alt+Shift+F10+C This is Keyboard shortcut to change Text value to Number…

2

Regards,

1 Like

Hello,
You must use Format Value Activity to change the Format.
But the Entered Variable is in Generic Value and change the format by using format Type List box…

Regards,

4 Likes

Hello,
I have the same problem as @leonardoancora.
I have to change the format of text into a number of a selected column


Can you kindly attach me a simple xaml of how to do it by using hotkeys?
Thank you so much @Hemanth

I couldn’t do it either.
Have you found any way/workaround?

Kr,
Felipe.

1 Like

Yes…I did it by recording activities in Excel.
If you want I can attach my xaml.
Camilla

1 Like

It’d be very helpful =)

1 Like

Sorry if i am a little bit strict. However, the correct way to this its with Format Value (As @poovarasan2 said).

The basic example is:

  1. Create a “Generic Value” variable
  2. Assign it a value (Any format whould be acceptable)
  3. Format value to define how you have wrote the value
  4. Write it to excel with a write cell

Using shortcuts its great if other solutions didn’t work however if you use a lot of workarounds then the process becomes unstable.

In case you wanna write lot of values with “write range” another solutions arise in order to write a lot of data in short periods of time. But thats problems for the future me :slight_smile:

1 Like