I'm entering an amount into a cell, but the screen shows a number altogether
different from what I type.
I checked the format of the cell. I couldn't see anything wrong.
I'm entering an amount into a cell, but the screen shows a number altogether
different from what I type.
I checked the format of the cell. I couldn't see anything wrong.
Maybe a stupid question, but...
What did you type and what did you see? And how was the cell formatted?
--
Kind regards,
Niek Otten
"CJ" <[email protected]> wrote in message
news:[email protected]...
> I'm entering an amount into a cell, but the screen shows a number
> altogether
> different from what I type.
>
> I checked the format of the cell. I couldn't see anything wrong.
If you tell us what you type and what you get it would help
Ed
Amount, hmm..., numbers?
Format>Cells>Numbers>Decimal places maybe
perhaps you typed in 0.899756 and are getting 1 because you have 0 or too
few decimal places formatted....????
"EdMac" wrote:
>
> If you tell us what you type and what you get it would help
>
> Ed
>
>
> --
> EdMac
> ------------------------------------------------------------------------
> EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
> View this thread: http://www.excelforum.com/showthread...hreadid=504934
>
>
Can't say for sure without an example, but try these two solutions.
I. Under Tools->Options->Edit Tab
Make sure the "Fixed Decimal" is unchecked. This will change 260 to 2.6 and
2620 to 26.2.
II. Check the formatting. You might have a strange custom number format like
1234
this will make any number entered show up as 1234 instead of the number.
Change it to General or Number or something more appropriate.
"CJ" wrote:
> I'm entering an amount into a cell, but the screen shows a number altogether
> different from what I type.
>
> I checked the format of the cell. I couldn't see anything wrong.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks