View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Why do I get #### signs when entering cash amount in account mode

Just make the column a little wider.

Accounting format has spaces added by default to account for the possible
insertion of parenthesis, where the positive and negative numbers will align
with each other.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"banae9" wrote in message
...
I have my cell formated in accounting and when i enter my cash amount it
gives me ##### signs. I have changed the format to anything other than
accounting and it puts in my amount. I want my workbook in accounting mode
because it is easier to read for me. What on earth have I dont wrong to
the
thing? Please help..