| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto format problems
I am trying to track groups of kittens born at our shelter in excel. When
born, each kitten is given a letter, a number, and then they year so, the first kitten of the first litter this year is A1-06, the second one in that litter is A2-06, etc. The next litter would be B1-06, etc. Anyway, when we put those ID's into excel, excel automatically changes it into something that looks more like hebrew or some other non-english alphabet. I know there is something in excel that I can change to fix that problem, but I can't for the life of me remember where or what it is! Please please help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
auto format problems
Put a ' sign in front of the number.
Let us know! "Meg" wrote: I am trying to track groups of kittens born at our shelter in excel. When born, each kitten is given a letter, a number, and then they year so, the first kitten of the first litter this year is A1-06, the second one in that litter is A2-06, etc. The next litter would be B1-06, etc. Anyway, when we put those ID's into excel, excel automatically changes it into something that looks more like hebrew or some other non-english alphabet. I know there is something in excel that I can change to fix that problem, but I can't for the life of me remember where or what it is! Please please help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto format rows according to field data | Excel Discussion (Misc queries) | |||
| Date format problems ... | Excel Discussion (Misc queries) | |||
| Which Excel version has the slide transparency in format auto shap | Excel Discussion (Misc queries) | |||
| auto format chart colours | Excel Discussion (Misc queries) | |||
| Time Format Auto Entry AM and PM | Excel Discussion (Misc queries) | |||
Linear Mode
