Hi all,

I am working on a game in excel and am using numerical IDs to calculate when/where the characters, walls, enemies, etc. will populate. For example, 1 is a wall, 0 is a movable/open space, -1 is the player, -2 is an enemy, -3 a non-player character, -4, and so on. I was using a custom number format, [=-1]"Bob";[=-2]"Bat";"" but when I try to continue with [=-3] and so forth it gives me an error. I am inclined to think this is a limitation of the custom number formats but I hope someone has a solution or workaround.