LinkBack URL
About LinkBacks
Hi,
For some reason my formula creates a value that I cannot adjust the decimal points for?
Any ideas?
Thanks in advance
Sam
Hi,
For some reason my formula creates a value that I cannot adjust the decimal points for?
Any ideas?
Thanks in advance
Sam
Is the value returned in text form?
________________________________________________________
If your problem is solved, update the thread as SOLVED: Go to the top of the first post-Select Thread Tools-Select Mark thread as Solved OR - Go to the first post - Click edit- Click Advance- Just below the word "Title:" you will see a dropdown with the word No prefix.- Change to Solve- Click Save.
Show your gratitude to the person who helped you solving your problem by clicking on star button at the bottom of such post.
Probably cannot help much without knowing what the formula is.
Is it a text formula (mid, left, right, etc) that generates a text string rather than a real number? If so, you might nest the whole thing inside of the VALUE() function. http://office.microsoft.com/en-us/ex...583.aspx?CTT=1
Originally Posted by shg
Hi,
No, currency.
I think I have figured it, sorry. The formula contained SUBSTITUTE which when removed now returns the correct value?
I can get around this by using the correct terminology in the look up table.
Any ideas why this happens for future reference?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks