16 Jul 2008 at 19:40 #1 Nice1 Nice1 Associate Joined 25 Jun 2003 Posts 140 Location Scotland When i input the text 1E5 into the cell it changes to 1.E+05, how on earth do i just get it to remain as 1E5. Its doing my head in.
When i input the text 1E5 into the cell it changes to 1.E+05, how on earth do i just get it to remain as 1E5. Its doing my head in.
16 Jul 2008 at 19:56 #5 Nice1 Nice1 Associate OP Joined 25 Jun 2003 Posts 140 Location Scotland Richiev4 said: Right click the cell and select 'Format Cells...' change the category to 'text', you may need to enter the text again. Rich Click to expand... This worked. Thanks
Richiev4 said: Right click the cell and select 'Format Cells...' change the category to 'text', you may need to enter the text again. Rich Click to expand... This worked. Thanks
