formatting a function

  • Thread starter Thread starter pbuscio
  • Start date Start date
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?
 
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 ...
 
(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
 
Back
Top