John_356
New Member
- Joined
- Jan 17, 2021
- Messages
- 26
- Office Version
- 365
- Platform
- Windows
Good day,
I'm dealing with a big database with lots of figures entered manually over the years by multiple different people. These people did not know any better than not to respect the previous one's format so it adds up to a huge database with cells with actual points and commas as well as formatted cells and currencies written with actual letters.
Any idea on how to deal with this? I'm thinking of a find/replace logic but can't figure it out so far.
Cheers to whomever gets me out of this one!
I'm dealing with a big database with lots of figures entered manually over the years by multiple different people. These people did not know any better than not to respect the previous one's format so it adds up to a huge database with cells with actual points and commas as well as formatted cells and currencies written with actual letters.
Any idea on how to deal with this? I'm thinking of a find/replace logic but can't figure it out so far.
Cheers to whomever gets me out of this one!