Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Beginner MS Project

Beginner MS Project

Beginner MS Project

Hi guys!
I'm brazilian and this is my first post! bigsmile

I'm really happy to find a forum to help me out.
And my first question is, I've created a custom column with a simple formula.
SO I'm trying to put a prefix in my formula. The formula will give just a number (e.g 5.000,00) I'd like to insert a prefix (R$ 5.000,00).

Anybody Can help me out please?

Thank in advance
Sorry for my poor english

RE: Beginner MS Project

If you create your formula in a spare cost field, it should pick up the prefix set in File > Options, Display for currency. If not, depending upon what type of field you created the custom formula in (Text? Number?) you may be able to add the prefix.

RE: Beginner MS Project

Great. Do you have what you need?

RE: Beginner MS Project

Hi Julie,
Yes, I do Julie.
But If I create a custom column as a number, I couldn't add prefix (R$).

My Formula:
[Fixed cost]*1,26

Thank in advance

RE: Beginner MS Project

But all works fine in a spare cost field. You are correct - the only thing that may be entered into a number field is numbers.

RE: Beginner MS Project

So, It is not possible add a prefix into number field?

Ok Julie. Many Thanks for your assistence!


RE: Beginner MS Project

No. You cannot add a prefix to a number field. You can perform math in formulas in text fields and add the prefix there. The only thing that can be in number fields are numbers - no formatting - no prefixes.

RE: Beginner MS Project

I get it
Thank you, Julie!

RE: Beginner MS Project

You're most welcome and thanks for the feedback.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close