| View previous topic :: View next topic |
| Author |
Message |
mblasucci
Newbie
Joined: 27 Dec 2005
Posts: 1
|
 Posted: Tue Dec 27, 2005 7:45 am Post subject: Format a number within a formula including text. |
 |
|
I'm using a Formula similar to following in order to generate a text including a number from another cell:
="This is a test only. Following number should be formated as currency: " & A41 & " Unfortunately this number losses its original format."
Does anybody know how I can format this number as part of the text? Thanks for your help. |
|
| Back to top |
|
 |
AndrewZ
Moderator
Joined: 21 Jun 2004
Posts: 4140
Location: Colorado, USA
|
| Posted: Tue Dec 27, 2005 6:08 pm Post subject: |
|
|
| Try the spreadsheet function TEXT which converts a number to text and allows you to specify the format. |
|
| Back to top |
|
|
|
