formatting a function

P

pbuscio

I have an iif function that pulls in either a date or a percentage. The date is fine, but when it is a percentage it is a date or a time. How do i format?
 
B

Bob Barrows

I have an iif function that pulls in either a date or a percentage.
The date is fine, but when it is a percentage it is a date or a time.
How do i format?
Click to expand...

There is a Format() function. It returns a string in a specified format.
If that doesn't help, we can't debug what we can't see ...
 
P

pbuscio

(e-mail address removed) wrote: > I have an iif function that pulls in either a date or a percentage. > The date is fine, but when it is a percentage it is a date or a time. > How do i format? There is a Format() function. It returns a string in a specified format. If that doesn't help, we can't debug what we can't see ...
Click to expand...

i used format percent and it worked
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project. Real progress of the project, % complete 1
Doughnut Chart linked with the slicer in the pivot table 0
Resource name inside resource sheet: per person, work per hours per week 0
Countdown macro - display settings 2
Printing Outline view - formatting lost 0
Formatting templates 7
Dcount -Date Criteria - Won´t find it - 0
Grouping Names in Mail Merge 0

Top