1) Not only this cannot be called "format" - because it is a real
Multiplication, by 1,000, of every number you type - be aware that this will
take place in ANY CELL / IN ANY SHEET / IN ANY WORKBOOK (!!!) until you
switch it back to 0.
2) Lets assume that you typed values into 10 cells [B1:B1] and now you want
to edit B3.
[In B3 you types 1,234 which immediately changed into 1,234,000]
Take a good look what happens if, by mistake(!), you entered the edit mode
of cell B4 - hit [F2] or Double-Click that cell and then pushed [Enter] or
left that cell by selecting another cell...
3) Suppose you want to edit a long number by changing only ONE of its digits.
*** Try all the above... ***
Micky
Faraz A. Qureshi said:
Jacob u r the best buddy!
--
Thanx again,
Best Regards,
Faraz