Numbers format in schedule

[Tra]

Hi All, I have a few questions regarding the cell format in the schedule.

1. is there a way to add a thousand separator "," to all the numbers in price column?

2. is it possible to add a dollar sign icon?

3. Can we input the words "grand total" in  the cell before the 122186.

Thanks so much.

Operating system used: Windows 10

[vistasp]

Digit grouping and the $ sign should be possible using Properties.

I don't know of any way to add the words Grand Total, though.

[Tra]

Thanks for your response, But I still don't quite understand. I've already set the digit grouping in the windows control panel, but I still can't add the dollar sign and separator in Archicad.

[vistasp]

Digit grouping from your OS won't help here.

You'll have to use the Property Manager and create a new property which does what you want. This property can then be inserted into the schedule in place of the price information for the element.

As an example:

I don't know of an easy way to split the price data for inserting the commas, but maybe someone who has already done so will chime in.

[Barry Kelly]

The problem with creating a property to show $ symbol, is it will now be a string and it won't total in the schedule.

I would just live with "$" in the column/row title which you can customise to say what ever you want.

Barry.

[Tra]

Yes, You're right. 

[vistasp]

Yes, I didn't think of that. Which shows how little I use Properties. 😅