LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 40
Default Format Cell Problem

Hi,

Sorry for all these dumb questions, but I never had any problems with Excel
97.

This one is apparently just too complicated for me at my old age.

Anyway, thanks for all the help; really appreciate it.

So, using Excel 2007, and XP

I select a cell that has a number in it with 5 decimal places.
I go to Format Cells, and select Number, and tell it to go to 4 decimal
places.

It won't, and continues to show 5 decimal places.

This is also true if I try it on a column of numbers.

What am I not doing right ?
(I am sure that what appears in the cell is truly a number, and not text.)

Thanks,
Bob


 
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
Cell format problem Carey Excel Discussion (Misc queries) 2 November 20th 08 10:18 PM
format cell problem Murat Gordeslioglu Excel Discussion (Misc queries) 2 June 7th 06 02:39 PM
Cell format problem Barb Excel Discussion (Misc queries) 6 March 6th 06 08:31 PM
Format cell problem Winnie Excel Discussion (Misc queries) 1 February 16th 06 11:40 AM
cell format problem kumarappans Excel Discussion (Misc queries) 3 November 26th 04 05:36 PM


All times are GMT +1. The time now is 11:16 AM.

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"