- 8 Posts
- 14 Comments
I tend to lean towards it being humidity since we have only noticed it happened in the last couple of weeks where temperatures in this area are higher than normal, humid and our AC has not been working for months (just had it repaired today).
This worked exactly as I needed it to. Thanks so much!
Yeah i think the format of the sheet I was using was out of whack based on all my attempts at correcting it, I was able to paste into a brand new sheet and got the results I needed using another users suggestion of =TEXT(B2, “0.000”) which was a success! Thanks for the guidance!
yeah it absolutely has to have the .000 because it will be using that to reference another database to sync based on that client id. How do I convert numbers to strings?
Not coming off as obtuse, and i’ll try my best to explain the issue but I do understand what you are saying.
The goal is I am doing an import of clients into our system for an integration so the info syncs correctly and we sync using the Client ID, which is case sensitive.
When I imported the data into my system, i want to import the Client ID - 1105416.000 (what i see in the cell). When using my importer tool to match the corresponding fields in our system with the field in the spreadsheet, the value example the importer tool is showing is Client ID - 1105416, which is incorrect. I ran a small sample to test and it imported as 1105416, but it has to be 1105416.000
ChatGPT gave me the same suggestion but didn’t fix the issue.
Millennial_Falcon@lemmy.worldOPtoHome Improvement@lemmy.world•What is this control for and how do I use it?10·2 months agoAwesome, did more digging and it turns out it’s an HRV and likely not something I need to be running during the summer months as I don’t need more warm air circulating and we keep windows open often enough to naturally exchange the air.
Millennial_Falcon@lemmy.worldOPtoHome Improvement@lemmy.world•Connect Mini Split to Air Circulator system?1·2 months agoUnfortunately with the house layout there isn’t a good spot to put a fan at the top of the stairs as it will block the narrow hallway that exists between the bedrooms as well can’t put it on the stairs because they are spiral.
Millennial_Falcon@lemmy.worldOPtoHome Improvement@lemmy.world•Connect Mini Split to Air Circulator system?1·2 months agoYeah not the most handy person and electrical freaks me out so expecting the higher cost of having a professional do it but luckily where i live (Canada) there are federal programs that offer rebates on things like this if the options we choose are eco friendly so, might be expensive but we should get money back providing we follow the regulations.
Millennial_Falcon@lemmy.worldOPtoHome Improvement@lemmy.world•Connect Mini Split to Air Circulator system?11·2 months agoYeah I think the split isn’t enough for the house, not sure how they withstood the humid temperatures through the summer, especially the kids rooms. Can’t see how many BTU’s the current system is but probably going to need to upgrade that unit and add more wall units. Unsure what to do about the kids rooms at night though with there doors closed there is no way the cold air will get in and a fan will only push the hot air around. We have a portable AC that looks like a mini-fridge, but my concern is leaving that in room with the toddler as I want to avoid an accident of it falling onto her.
Millennial_Falcon@lemmy.worldOPtoHome Improvement@lemmy.world•Connect Mini Split to Air Circulator system?2·2 months agoAh good point, I didn’t think of the consequences of mixing the different air temperatures through the ducts. Ideally I would like to avoid blowing mold all throughout my children’s bedrooms.
Millennial_Falcon@lemmy.worldto World News@lemmy.world•Trump’s US doesn’t just think Europe is obsolete – it wants to see it deadEnglish55·3 months agoYou really believe Denmark is looking at the Trump’s administration approach as something to model itself after? What are the common issues Denmark is facing that match the US response?
Millennial_Falcon@lemmy.worldto World News@lemmy.world•Trump’s US doesn’t just think Europe is obsolete – it wants to see it deadEnglish88·3 months agoCurious, why are strict immigration laws a “dark path”?
Yeah it goes back in place and fits perfectly once i push it back into place. I’ll go the glue and nail route. Thanks!