dnguyen1022
04-20-2011, 07:43 AM
Hi all,
I've been looking at a few examples on custom formatting for excel but I can't seem to grasp it for what I need. I want to create a custom format that will allow me to have two numbers with commas in a cell separated by a /.
Ex: 1,234,567.123 / 987,654.432
The code that I wrote retrieves these two numbers by calculating a range of numbers from a separate worksheet.
It looks very similar to this:
currentRange = Calculation1(Cell.Value) & " / " & Calculation2(Cell.Value)
However when I do this, the values that I see in the spreadsheet does not display commas.
Ex: 1234567.123 / 987654.432
What would be the best way to get the result I want?
I've been looking at a few examples on custom formatting for excel but I can't seem to grasp it for what I need. I want to create a custom format that will allow me to have two numbers with commas in a cell separated by a /.
Ex: 1,234,567.123 / 987,654.432
The code that I wrote retrieves these two numbers by calculating a range of numbers from a separate worksheet.
It looks very similar to this:
currentRange = Calculation1(Cell.Value) & " / " & Calculation2(Cell.Value)
However when I do this, the values that I see in the spreadsheet does not display commas.
Ex: 1234567.123 / 987654.432
What would be the best way to get the result I want?