custom a cell
 

How do make that when I enter 1234 its should come out 12.34


--
shlomo
------------------------------------------------------------------------
shlomo's Profile: http://www.excelforum.com/member.php...o&userid=15304
View this thread: http://www.excelforum.com/showthread...hreadid=346808

Format Cell Number change decimal and symbol


--
Cissy
------------------------------------------------------------------------
Cissy's Profile: http://www.excelforum.com/member.php...o&userid=20107
View this thread: http://www.excelforum.com/showthread...hreadid=346808

Right click cell, select 'Format Cell' and select 'number'

"shlomo" wrote:


How do make that when I enter 1234 its should come out 12.34


--
shlomo
------------------------------------------------------------------------
shlomo's Profile: http://www.excelforum.com/member.php...o&userid=15304
View this thread: http://www.excelforum.com/showthread...hreadid=346808

Easiest way would be to go to ToolsOptionsEdit and checkmark "fixed deimal
places" and set to 2.

Otherwise divide 1234 by 100 after the fact.

Enter 100 in an empty cell then Copy that cell.

Select the other cell with 1234 and Paste SpecialDivideOKEsc.

Others have posted that you can change 1234 into 12.34 by formatting.

You would still have 1234 as a value no matter how you format it.


Gord Dibben Excel MVP

On Fri, 18 Feb 2005 10:30:16 -0600, shlomo
wrote:


How do make that when I enter 1234 its should come out 12.34