How do I Convert a number to text?

[Carissapaige]

Hi! I am very new with excel.
I need to convert my currency to a text in the column after my number. It looks like it should be as simple as =TEXT(D264), however that is throwing an error.
After researching, it looks like i need a to create a Macro, but like i said, I am very new to this so I do not know how to do so.

TYIA!

 

[Fluff]

You need to specify the format like

=TEXT(D264,"$#,##0.00")

 

[Carissapaige]

You need to specify the format like

=TEXT(D264,"$#,##0.00")

Thank you, but this still shows me the number instead of converting it to words.

 

[Fluff]

That's what I thought you wanted. If not what do you want?

 

[Carissapaige]

I need the text to display in the next column beside the number.
For example my number would be $208,000.00. I want "Two Hundred Eight Thousand" to show in the next column

 

[ExceLoki]

do you mean something like $1.43 = one dollar and forty-three cents?

 

[ExceLoki]

just saw your last post

 

[Carissapaige]

do you mean something like $1.43 = one dollar and forty-three cents?

Yes!

 

[ExceLoki]

Convert numbers into words - Microsoft Support

Discover how to convert numbers into English words in an Excel spreadsheet using the SpellNumber sample function.

support.microsoft.com