Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Marcelo
 
Posts: n/a
Default how change number in cell to text

I need change de value (number) in plain text.
Example: insert in collum A1 "R$ 5,57" and show in collum A2 "cinco reais e
cinquenta e sete centavos"

I,m in Brazil and reais is the currency money.
  #2   Report Post  
Barb Reinhardt
 
Posts: n/a
Default

I believe you are asking if you can change

1 to one
2 to two
3 to three (or the spanish equivalent)

Is this correct?

"Marcelo" wrote in message
...
I need change de value (number) in plain text.
Example: insert in collum A1 "R$ 5,57" and show in collum A2 "cinco reais
e
cinquenta e sete centavos"

I,m in Brazil and reais is the currency money.



  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

See http://www.xldynamic.com/source/xld.xlFAQ0004.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Barb Reinhardt" wrote in message
...
I believe you are asking if you can change

1 to one
2 to two
3 to three (or the spanish equivalent)

Is this correct?

"Marcelo" wrote in message
...
I need change de value (number) in plain text.
Example: insert in collum A1 "R$ 5,57" and show in collum A2 "cinco

reais
e
cinquenta e sete centavos"

I,m in Brazil and reais is the currency money.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Reverse Contents in an Excel cell (Text or a Number) CeeGee Excel Worksheet Functions 5 September 13th 07 06:22 PM
number formatted cell Pam Coleman Excel Discussion (Misc queries) 2 June 2nd 05 08:44 PM
Change column Number vrs Text an Excel Worksheet Functions 2 January 28th 05 12:22 PM
Defining a number in a cell by text then subtracting it by the tex Crowraine Excel Worksheet Functions 1 December 16th 04 07:49 AM
How do i change numbers in text format to number format? Greg New Users to Excel 1 December 14th 04 05:22 PM


All times are GMT +1. The time now is 12:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"