Excel wont save properly, deletes newly created tab upon save and removes spacing of number in different cells

Hello, I am trying to create a new tab in excel based on the project name, but for some reason, whenever i run it, it works, then I save it, then i imediately open it back up and the newly created tab has been deleted and the data from that tab has gotten moved to the originial tab, only its spacing (each number was in its own cell) has been removed and now I get this: anyone know whats going on here is this weird .csv style thing? Please advise!

That is how CSV is going to work. It won’t keep any of your formatting unless you save it to an .xlsx file because CSV is just dummy text values.

1 Like