Steffmeister
Board Regular
- Joined
- Nov 7, 2005
- Messages
- 195
Hi guys,
I got a very weird problem. When I type in an IP-address some of them get no point between the numbers.
Example: 9.155.230.148 this address will show with points in the cell, but in the formula bar he shows without points 9155230148
When I put the Format cell as number and use the seperator then he still have no points in the formula bar.
Will this be a problem when I want to compare the sheets with addresses? Is he get the address in the cell or the formula bar?
Hope you can help me.
Grts. Steffmeister
I got a very weird problem. When I type in an IP-address some of them get no point between the numbers.
Example: 9.155.230.148 this address will show with points in the cell, but in the formula bar he shows without points 9155230148
When I put the Format cell as number and use the seperator then he still have no points in the formula bar.
Will this be a problem when I want to compare the sheets with addresses? Is he get the address in the cell or the formula bar?
Hope you can help me.
Grts. Steffmeister