Excel cell formatting

[SorryButImaNewbie]

Hello again dear forum users!

I just spent 20-30 minutes searching for it in the forums, but so far, I haven't found it. If you happend to have a topic with this question pls link it.

So, I would like to format a cell I inserted in to my excel doc, with excelRangeInsert. I would Like to format it to currency and if possible set decimal places to display to zero.

How do I do that? Didn't find corresponding  _excel UDF, and don't know how to do it with COM.

Thank you for the help

[AutoBert]

from Helpfile:

Quote

_Excel_RangeWrite

Writes value(s) or formula(s) to a cell or a cell range on the specified workbook and worksheet

 

[SorryButImaNewbie]

I don't get it.

If I write something (a string) in to a cell like: =SUM(range) and then I want to instruct the cell to display the value as a kind of currency, how do I do it?

If I read the value, it gives back the function, like =SUM(range) I cant transformt that to integer and Round() it. and add regex USD at the end.

[water]

This page in the wiki should give you an idea

https://www.autoitscript.com/wiki/Excel_UDF#Format_a_range