Forum Discussion
F/S presentation
I have the English version of Excel. I have to prepare F/S with a French presentation. Is there any way I can access the Fench presentation, i.e., space instead of a comma and dollar sign at the end rather than at the beginning? Thanks.
Just seeing you post now. Three days after you posted it.
From what you describe you want something like this:
Then use a custom format like this:
# ##0_)"$";(# ##0)"$"
I don't know how you want to show negatives. I assumed within parentheses. You can always change that of course.
3 Replies
Thank you!
Riny's fine reply works well for numbers between -999999 and +999999:
If you want to accommodate numbers outside that range, you should set the grouping symbol in your operating system for numbers and currency to a space.
Or use a format such as
[>=1000000]0 000 000 "$";[<=-1000000]-0 000 000 "$";# ##0 "$"
which will work for numbers between -999999999 and +999999999.
Just seeing you post now. Three days after you posted it.
From what you describe you want something like this:
Then use a custom format like this:
# ##0_)"$";(# ##0)"$"
I don't know how you want to show negatives. I assumed within parentheses. You can always change that of course.
