System.FormatException: Input string was not in a correct format.

  • Thread starter Thread starter Matthew Prestipino
  • Start date Start date
M

Matthew Prestipino

Guest
Some context: This error message appeared to the person I send an excel file to. I upload a file to Visual Studio and someone downloads and then imports that excel file into their system and because of this the formatting of the file cannot change.
This is a new task for me, but what you would normally do is change some data in cells that are a General format. You do need to change the dates and this is where I think the error message arose from.
The date columns are formatted to Date. If I click on a date cell, it is X Date layout and if I were to update the date using the formula bar keeping the layout the same, then press enter, the layout of the date changes. Which seems strange. Anyhow I hope this provides some context to help you - help me!

Any help would be really appreciated. Thanks.

Link to error message screenshot:
https://microsoftapc-my.sharepoint....FCppXFn4H6Rw0BXK7SNGrqErR8JBH_TMPwxw?e=hkwsra

Continue reading...
 
Back
Top