I've done this before but can't recall now. I'm sure it's a simple solution. I'd appreciate any tips on the attached file. Thank you.
I've done this before but can't recall now. I'm sure it's a simple solution. I'd appreciate any tips on the attached file. Thank you.
Try this formulaPlease Login or Register to view this content.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Is this simple solution answer to your question?
All numbers greater than 5 digits are divided by 100 using this formula
=IF(A2>9999,A2/100,A2)
/LGS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks