Write number in excel

Help
1

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
2

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,

2 Likes
3

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…

Capture
Capture698Ă—294 16.9 KB

Regards,

4 Likes
4

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

image
image1600Ă—900 83.6 KB

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

5

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

Kr,
Felipe.

1 Like
6

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

1 Like
7

It’d be very helpful =)

1 Like
8

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