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?
 
Ad

Advertisements

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?
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 ...
 
Ad

Advertisements

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 ...
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

Format Function 1
Format Function 5
Format Function 4
Format Function 2
Format() Function 2
Combine Format function? 7
Format Function - Percent 2
Format function for quarter 1

Top