View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default 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.