Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I stop cells formatting?
Hi,
I have some zip files of spreadsheets that I downloaded off the net displaying various odds for betting markets (betfair historical data). However for some of the cells which contain correct scores for football a date has been substituted e.g. 1 - 3 gets automatically converted to 1st March (or something). I normally get round this problem by formatting the relevant cells as text before entering the correct score, but I can't do this since they have already been converted on unzipping. If I format as text afterwards I just get mysterious 5 figure numbers. Any suggestion as to what I can do? I can't do it one by one manually because they might be 10s of thousands of correct scores which have been converted into a date. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How stop auto formatting? | Excel Discussion (Misc queries) | |||
Stop automatic formatting of cells (number, text, date, etc) | Excel Worksheet Functions | |||
Stop cells auto-formatting | Excel Discussion (Misc queries) | |||
How to get Excel to stop formatting time cells incorrectly | Excel Discussion (Misc queries) | |||
How do I stop other circles in other cells to stop selecting? | Excel Worksheet Functions |