Hello i would like to insert Currency value to cell as text and just convert it to real currency format like 125.00 HUF with the following format:So the text inserted value is same as format code output, but it cannot appliy while the " HUF" suffix is given, but if i delete from the end of string it work perfect: same as text.Please Login or Register to view this content.
So somehow i need to force exel to interpret the Currency value and suffix without i cut down the suffix manualy.
Bookmarks