Write cell Preserve format question

[A_Learner]

Excel how to preserve format with write cell. I am writing “0000” and Excel cell it is turning into one zero.

Thank you,

[ppr (Peter Preuss)]

@A_Learner

“0000”

write "'0000" or reformat cell/ range afterwards

[pravallikapaluri]

Hi @A_Learner
Check the below thread

The excel application scope change the data

Hi, Excel does this by default. Like if you were to enter the numbers manually, it will do the same thing. The solutions to this are one of the following, I think: If the numbers are already zero-filled as strings, format column to text prior to writing data so they stay zero-filled Keep the values as numbers but format the column with a Custom format, 0000, so it is zero-filled Change the number to start with a single quote, ‘0025 or "’"+25.ToString(“0000”) Use a formula to convert number t…

Hope it helps!!

[A_Learner]

Thank you, @pravallikapaluri and @ppr