Convert numbers in to text

[xandertio]

Hi all,

Please help me with the following dilemma. I am using excel to create invoices via MS Word. But word cannot handle numbers correctly, format issue, so I am converting numbers in Excel to text.

The problem I have know is that converting numbers in excel tot text Excel only shows the characters that are actually typed in the cell. For example 34,40 (as number) will be in text 34,4. I am looking for the text 34,40 which I want to use in Word.

Please let me know what I have to do.
Thank you
Xander

 

[Special-K99]

I dont understand.
If I type 34,40 into a cell it displays 34,40, exactly as I typed it.

 

[VoG]

Try ASAP Utilities http://www.asap-utilities.com/asap-utilities-excel-tools-tip.php?tip=76&utilities=67&lang=en_us

Edit: I think I misunderstood the question.

 

[xandertio]

I would love to show you guys a printscreen but for some reason I can't.

 

[xandertio]

See printscreen below:

thank you
Xander

 

[VoG]

Try using Excel Jeanie http://www.excel-jeanie-html.de/html/hlp_schnell_en.php