Convert numbers in to text

xandertio

New Member
Joined
Nov 25, 2009
Messages
25
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
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,350
I dont understand.
If I type 34,40 into a cell it displays 34,40, exactly as I typed it.
 

xandertio

New Member
Joined
Nov 25, 2009
Messages
25
See printscreen below:



thank you
Xander
 

Watch MrExcel Video

Forum statistics

Threads
1,119,288
Messages
5,577,212
Members
412,776
Latest member
nadroy87
Top