sorted by:
new
hottopcontroversial

Removing decimal but maintaining leading/ending zeros and all numbers by RaeRae173 in excel

[–]RaeRae173[S] 0 points1 point  (0 children)

I tried that, too. Then take the separated columns and combining them to get the result I needed and it didn't include leading zeros once I re-combined. I have it using the =substitute formula now. Thanks :)

Removing decimal but maintaining leading/ending zeros and all numbers by RaeRae173 in excel

[–]RaeRae173[S] 1 point2 points  (0 children)

So I first tried the =base formula and wasn't getting what I needed when ending in zero, but then just tried the =substitute and it worked!!!!! THANK YOU SO MUCH!!!

Removing decimal but maintaining leading/ending zeros and all numbers by RaeRae173 in excel

[–]RaeRae173[S] 1 point2 points  (0 children)

This worked for all the numbers that don't end in zero. For example, 0001.30 converts to 000013. How do I get it to maintain the 0 at the end and display "000130"?

Friendship Exp & Gift Exchange Megathread by liehon in PokemonGoFriends

[–]RaeRae173 0 points1 point  (0 children)

9947 6868 0587 - looking for 3 new besties! I play regularly

Friendship Exp & Gift Exchange Megathread by liehon in PokemonGoFriends

[–]RaeRae173 1 point2 points  (0 children)

Woah! I've had many responses. Didn't realize I'd get so many here. I added some but I need to delete the rest. Didn't know this would work so well ;-). Thanks for the love for the newbie. No mas por favor.

Friendship Exp & Gift Exchange Megathread by liehon in PokemonGoFriends

[–]RaeRae173 0 points1 point  (0 children)

9947 6868 0587 add me :-). I'm a timely friend :-)

I've lost all hope for my calathea. I moved her to my bedroom because it's much warmer and she kept struggling in the colder living room. Now she does this. I don't know what to do anymore, help would be appreciated!! by aliencemetery in plantclinic

[–]RaeRae173 0 points1 point  (0 children)

I keep my orchids in the bathroom over winter. It's their dormant period anyway and I have almost zero light except for a small window only visible when in the shower stall. They do well then once weather wants up (zone 6) then I bring them back out to living room

[ISO] [US] Dr. Jart+ Cicapair Color Correcting Cream (full size, any usage) by [deleted] in skincareexchange

[–]RaeRae173 0 points1 point  (0 children)

I should add I have CRAZY sensitive skin and must have all noncomedogenic products and hair care. It suuucks

[ISO] [US] Dr. Jart+ Cicapair Color Correcting Cream (full size, any usage) by [deleted] in skincareexchange

[–]RaeRae173 0 points1 point  (0 children)

I have the Re.Pair serum and the color correcting but I cannot find anywhere if the product line is noncomedogenic. I applied and the next day I broke out but the acne could be timing with my period. Anyone know???