(Msg. 1) Posted: Tue Oct 27, 2009 7:13 am
Post subject: change the format of cell Archived from groups: microsoft>public>excel>newusers (more info?)
I have uploaded an excell spreadsheet and seem that all cells are text
formatted.
I can`t change to fromat of cell to number.
"Format cell" dosen`t working or change anything.
(Msg. 2) Posted: Tue Oct 27, 2009 11:18 am
Post subject: Re: change the format of cell [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Tue, 27 Oct 2009 07:13:01 -0700, Exceller
<Exceller.RemoveThis@discussions.microsoft.com> wrote:
>I have uploaded an excell spreadsheet and seem that all cells are text
>formatted.
>I can`t change to fromat of cell to number.
>"Format cell" dosen`t working or change anything.
Changing the format will not do that.
You need to coerce these values to numbers by performing a math operation.
One method, after formatting the cells as General or Number:
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office