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?

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

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

Top