numbers not appearing correctly in formula bar
 

I have a spreadsheet that someone else created and that has a field called
CURBAL for current balance. This field shows the amount 18.6 instead of
18.60. I have tried changing the number in the formular bar but the minute I
go to the next cell it changes back. I cannot find any formula and it
appears the cell is GENERAL. How can I correct this. And how can I change
the template file to keep this formatting.

numbers not appearing correctly in formula bar
 

Format/Cells/Number, select Number and 2 decimals. Then save the template.

"Kate" wrote:

I have a spreadsheet that someone else created and that has a field called
CURBAL for current balance. This field shows the amount 18.6 instead of
18.60. I have tried changing the number in the formular bar but the minute I
go to the next cell it changes back. I cannot find any formula and it
appears the cell is GENERAL. How can I correct this. And how can I change
the template file to keep this formatting.

numbers not appearing correctly in formula bar
 

Click the toolbar button that looks somewhat like this...
+.0
..00

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Kate"
wrote in message
I have a spreadsheet that someone else created and that has a field called
CURBAL for current balance. This field shows the amount 18.6 instead of
18.60. I have tried changing the number in the formular bar but the minute I
go to the next cell it changes back. I cannot find any formula and it
appears the cell is GENERAL. How can I correct this. And how can I change
the template file to keep this formatting.

numbers not appearing correctly in formula bar
 

I did that and the amount shows in the spreadsheet as $18.60 but on the
formula bar a 18.6. When I import this spreadsheet into a word document this
field appears
18.60 instead of $18.60.

Kate
"JMB" wrote:

Format/Cells/Number, select Number and 2 decimals. Then save the template.

"Kate" wrote:

I have a spreadsheet that someone else created and that has a field called
CURBAL for current balance. This field shows the amount 18.6 instead of
18.60. I have tried changing the number in the formular bar but the minute I
go to the next cell it changes back. I cannot find any formula and it
appears the cell is GENERAL. How can I correct this. And how can I change
the template file to keep this formatting.

numbers not appearing correctly in formula bar
 

JMB gave you the correct answer pertaining to your post since you didn't
mention currency, if you want currency format as currency in the same place
you formatted as number.


--
Regards,

Peo Sjoblom



"Kate" wrote in message
...
I did that and the amount shows in the spreadsheet as $18.60 but on the
formula bar a 18.6. When I import this spreadsheet into a word document
this
field appears
18.60 instead of $18.60.

Kate
"JMB" wrote:

Format/Cells/Number, select Number and 2 decimals. Then save the
template.

"Kate" wrote:

I have a spreadsheet that someone else created and that has a field
called
CURBAL for current balance. This field shows the amount 18.6 instead
of
18.60. I have tried changing the number in the formular bar but the
minute I
go to the next cell it changes back. I cannot find any formula and it
appears the cell is GENERAL. How can I correct this. And how can I
change
the template file to keep this formatting.