Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
G4
 
Posts: n/a
Default Column Formatting

I am using Exell 2003, when i enter a number it appears as a 2 decimal place
fraction, rather than a full number.
The work sheet was created, originally in Office 97
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

Are you saying that the number is correct, just rounded to two decimal
places? If so, reformat the cell(s) as General.

If you mean say 100 is showing as .01, this sounds like Fixed Decimal. Go to
menu ToolsOptionsEdit and uncheck the Fixed Decimal box.

--
HTH

Bob Phillips

"G4" wrote in message
...
I am using Exell 2003, when i enter a number it appears as a 2 decimal

place
fraction, rather than a full number.
The work sheet was created, originally in Office 97



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I select hiding a column as a conditional formatting? Teresa Excel Discussion (Misc queries) 3 July 28th 05 05:45 PM
Lookup Table Dilemma Karen Excel Worksheet Functions 2 June 10th 05 08:22 PM
Conditional formatting applicable to entire column jackalx Excel Worksheet Functions 1 May 26th 05 05:20 PM
Conditional Formatting, reference another column DavidL Excel Worksheet Functions 4 April 7th 05 10:17 PM
Conditional formatting row if cell value in certain column is even Hyland Hunt Excel Worksheet Functions 1 February 2nd 05 08:21 PM


All times are GMT +1. The time now is 05:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"