numbers not appearing correctly in formula bar

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Click the toolbar button that looks somewhat like this...
+.0
..00

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


"Kate" <[email protected]>
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.
 
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 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.
 
Back
Top