cell formatting

[djackson]

I am inputting 4e6 in a cell and selecting the format for General so
this "4E6" will display as i want, but instead it keeps reverting to
Scientific. How do I get this to maintain the General Format? I looked
at the Auto Format function but this didn't work for what I am needing.
Any advise?

 

[Frank Kabel]

Hi
do you want to enter this as 'Text'. Then preformat the cell as 'Text'

 

[Norman Harker]

Hi djackson!

Try widening the column with General Format.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Mark Graesser]

Hi
A quick and dirty way to avoid having to reformat the cell as text is to precede your entry with an apostrophe. If you type

'4E

Excel will leave it as text. The ' will show in the formula bar but it won't show up in the cell

Good Luck
Mark Graesse
(e-mail address removed)

----- djackson > wrote: ----

I am inputting 4e6 in a cell and selecting the format for General s
this "4E6" will display as i want, but instead it keeps reverting t
Scientific. How do I get this to maintain the General Format? I looke
at the Auto Format function but this didn't work for what I am needing
Any advise