NIDHIN SANKAR
NIDHIN SANKAR

Reputation: 13

Number Format Code in excel getting Inavalid

In one of my project in which it export data into excel, we were trying to set the custom number format code for cells. But for one particular string the number format code was this

#######.##.##0#0#########################################################.##.###00######################################################.##.#0#00#####

while trying to open excel I was getting a repair message. enter image description here

I tried setting the custom format with the above mentioned format code. But I was getting error message message that this format code can't be set.

The value for the corresponding format code is a long sentence I am getting this code from an old method in my project. Can anyone please guide me why this format code is invalid.

Thanks in Advance.

Upvotes: 0

Views: 83

Answers (0)

Related Questions