Trouble with a formula, the result leaves out the commas
I have a formula
The result looks like
Please Login or Register to view this content.
My problem is if I format the cell as accounting to add in the commas it will not add them. I am not sure what I am missing here.Please Login or Register to view this content.
Any Help would be appreciated
And where should those commas be ?
How about this:
="Left to Complete "& TEXT(SUM(P6:P15) - 'VBA Sheets'!A3, "#,##0")
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
In the number. To seperate out thousands. I appologize if I was vague.Originally Posted by Pepe Le Mokko
Did you see post #3?
Worked great Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks