Hey,
I need some urgent help with this:
I'm pulling data from a database into Excel (CSV). Everything went fine initially, but there's a major issue—the numbers use periods as decimals instead of commas, and it's causing a massive headache.
Basically, a lot of values that should be 2.05 have turned into 2.something, because Excel keeps converting them into dates. If I try to change the cell format to number, the value just magically turns into 41396.00 instead of going back to 2.05.
How do I fix this?
I tried using Find / Replace to swap out the weird date strings with 05, but that just made everything even more chaotic...
There is no way I can fix this manually; we're talking about 300MB of data here...
The only thing making this slightly less painful is when I use Find / Replace to change .5 to ,5 or try to strip out things like .2013 by replacing them with , but then I run into another wall. I have to run way too many Find / Replace operations, and Excel treats 2.5 and 2.05 as the exact same date during conversion, so it ignores that extra zero... So yeah, that method is useless too...
🙂
If anyone knows a way to handle this, I'd really appreciate the help...
I need some urgent help with this:
I'm pulling data from a database into Excel (CSV). Everything went fine initially, but there's a major issue—the numbers use periods as decimals instead of commas, and it's causing a massive headache.
Basically, a lot of values that should be 2.05 have turned into 2.something, because Excel keeps converting them into dates. If I try to change the cell format to number, the value just magically turns into 41396.00 instead of going back to 2.05.
How do I fix this?
I tried using Find / Replace to swap out the weird date strings with 05, but that just made everything even more chaotic...
There is no way I can fix this manually; we're talking about 300MB of data here...
The only thing making this slightly less painful is when I use Find / Replace to change .5 to ,5 or try to strip out things like .2013 by replacing them with , but then I run into another wall. I have to run way too many Find / Replace operations, and Excel treats 2.5 and 2.05 as the exact same date during conversion, so it ignores that extra zero... So yeah, that method is useless too...
🙂
If anyone knows a way to handle this, I'd really appreciate the help...