View Full Version : Solved: Number Format
Hi,
how can i put a comma and two decimal places in a concatenated named range and string? pls refer to the attach file.. thanks..
:help
malik641
12-12-2006, 11:12 AM
Hey gnod,
Try using the Text function:
="This is to authorized your bank to debit the amount of Php " & TEXT(TotalAmount,"#,##0.00") & " from current account number:"
:thumb
Thanks.. :clap: :yes :clap: :yes :clap:
:thumb
JimmyTheHand
12-12-2006, 11:31 AM
I wonder how the function I used is called. (See attachment.) In Hungarian Excel, it is called "FIX", and by the look at the parameters it's a different function from TEXT.
So just that you have an alternative solution. :)
malik641
12-12-2006, 11:50 AM
In USA Excel, we have FIXED too. Cool, I didn't know about that function :) Thanks JimmyTheHand :thumb
And no problem gnod, glad to help :)
follow-up question: how can i make it bold the "TotalAmount" in the concatenated string and named range..
thanks..
does anyone have an idea??
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.