Question to put 'to record the first number 0 when saving Excel csv

Asked 1 weeks ago, Updated 1 weeks ago, 2 views

As far as I know, if the csv extension itself has a value of 01100, it does not recognize the format, but only the value is recognized as a number and stored as 1100.

I understand that you put '' in front of you to prevent it. If cell A1 had 01100, I thought it would be recognized as 01100 by entering the formula "&A1" in cell B1, copying the value of cell B1 back to cell A1, and erasing and storing cell B1, but it seems to be recognized as 01100.

How do I make it look like 01100 in the csv file?

excel

2022-09-20 11:08

2 Answers

If you write a CSV file in MS Excel, there are ways to set the cell value to ="01100" or specify the format as text, but if you save it as it is, it will appear to be 1100 when you open it again in Excel.

Because CSV doesn't save the format. https://answers.microsoft.com/en-us/msoffice/forum/all/is-there-any-way-to-save-a-formula-within-a-csv/1bea0dbc-09b2-4aca-a2a5-fbced28b42f9?auth=1

I don't think there's a particular way.


2022-09-20 11:08


2022-09-20 11:08

If you have any answers or tips


© 2022 pinfo. All rights reserved.